hacker rank The Report

select 
    case when g.grade >=8 then s.name else null end, 
    g.grade,
    s.marks
from students s join grades g
on s.marks between g.min_mark and g.max_mark
where s.marks > 8
order by g.grade desc, s.name, s.marks;