[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 nm
      ,g.grade
      ,s.marks
from students s
left join grades g
on s.marks between g.min_mark and g.max_mark
order by grade desc, name asc