[HR] The Report

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

• Basic Join > Join on range + case when

select case when g.grade < 8 then 'NULL' else s.name end as "Name"
      ,g.Grade
      ,s.Marks
from students s
left join grades g
on s.Marks between g.Min_Mark and g.Max_Mark
order by g.Grade desc, s.name asc, s.Marks asc;