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 "NULL"
else s.Name
end,g.grade,s.Marks from Students as s join Grades as g on g.Min_Mark <= s.Marks and s.Marks <= g.Max_Mark
order by g.grade desc,s.name asc;
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 →
work if case NULL insted of null
select case when g.grade < 8 then "NULL" else s.Name end,g.grade,s.Marks from Students as s join Grades as g on g.Min_Mark <= s.Marks and s.Marks <= g.Max_Mark order by g.grade desc,s.name asc;