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.
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks
from students,grades
where marks between min_Mark and Max_Mark
order by grade desc, name, coalesce(name,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 will also work for mysql
select (case when grade <8 THEN NULL ELSE name END) name, grade, marks from students,grades where marks between min_Mark and Max_Mark order by grade desc, name, coalesce(name,marks);