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 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;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Join us
Create a HackerRank account
Be part of a 26 million-strong community of developers
Please signup or login in order to view this challenge
The Report
You are viewing a single comment's thread. Return to all comments →
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;