CASE

HackerRank The Report [ MySQL ]

The Report | HackerRank Write a query to generate a report containing three columns: Name, Grade and Mark. www.hackerrank.com 조건문과 조인 Between을 사용하였습니다. 문제에 맞게 정렬 순서를 정하였습니다. SELECT CASE WHEN g.grade < 8 THEN NULL ELSE s.name END AS name , g.grade , s.marks FROM students s INNER JOIN grades g ON s.marks between g.min_mark AND g.max_mark ORDER BY g.grade DESC, name, s.marks