해커랭크 - The Report (SELECT + CASE)

https://www.hackerrank.com/challenges/the-report/problem?h_r=internal-search 

 

- SELECT 구문에서 CASE 활용해서 구분점 만들기
- 정렬기준 여러개
- INNER 조인 조건에 BETWEEN 사용할 수 있음.hacker_id

 

SELECT CASE WHEN g.grade <8 THEN NULL ELSE s.name END AS name
     , g.grade
     , s.marks
FROM students AS s
     INNER JOIN grades AS g ON s.marks BETWEEN g.min_mark AND g.max_mark
     
ORDER BY g.grade DESC, name ASC, s.marks