[HackerRank] Basic Select2 (마무리)

 

# Higher Than 75 Marks
select name
from students
where marks > 75
order by substr(name, char_length(name)-2, 3) asc, ID asc;

# Employee Names
select name
from employee
order by name;

# Emplotee Salaries
select name
from employee
where salary > 2000 and months <10
order by employee_id asc;

 

포인트:

Higher Than 75 Marks

이름에서 뒷부분 3개의 글자들 정렬: substr()로 지정된 길이 만큼 잘라서 반환한다.