We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
this is it:
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
order by g.grade desc, s.name, s.marks;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
this is it: 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 order by g.grade desc, s.name, s.marks;