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.
MySQL Solution:
The below solution adresses the case evn if there are more than one student with the same grade (1-7) assigned to them ans orders them by their marks
select if(grade >= 8, Name, NULL) as name, grade, marks
from students s join grades g
on s.marks between g.min_mark and g.max_mark
order by grade desc, if(grade >= 8,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 →
MySQL Solution: The below solution adresses the case evn if there are more than one student with the same grade (1-7) assigned to them ans orders them by their marks
select if(grade >= 8, Name, NULL) as name, grade, marks from students s join grades g on s.marks between g.min_mark and g.max_mark order by grade desc, if(grade >= 8,name,marks);