[SQL] HackerRank - Higher Than 75 Marks

Query the Name of any student in STUDENTS who scored higher than  Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.

Input Format

The STUDENTS table is described as follows: 

 The Name column only contains uppercase (A-Z) and lowercase (a-z) letters.

Sample Input

Sample Output

Ashley
Julia
Belvet

Explanation

Only Ashley, Julia, and Belvet have Marks > 75. If you look at the last three characters of each of their names, there are no duplicates and 'ley' < 'lia' < 'vet'.

 

문제해석

Marks 가 75보다 높은 Name들을 이름 마지막 3자 기준으로 정렬. 만약 이름 끝 3글자가 동일한 경우는 ID를 기준으로 오름차순 정렬

 

풀이

select name from students
where marks > 75
order by right(name, 3), id;

• right(name, 3)으로 Name컬럼의 오른쪽에서 3글자 기준으로 order by 

 

결과