[HackerRank] The Report

https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true 

The Report | HackerRank

 

select if(grades.grade>=8,students.name,"NULL"), grades.grade, students.marks
from students
join grades on students.marks between grades.min_mark and grades.max_mark
order by grades.grade desc, students.name asc, students.marks asc;