[해커랭크 SQL] Basic Select - Higher Than 75 Marks

❓ Question

https://www.hackerrank.com/challenges/more-than-75-marks

Higher Than 75 Marks | HackerRank

 

❗ Answer

SELECT name
    FROM students
    WHERE marks > 75
    ORDER BY RIGHT(name,3), id;

📌 Discussion

- WHERE에 조건을 걸어주고 ORDER BY에서 이름의 오른쪽 세글자 순으로 정렬해줌