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 if(Grade >= 8 , Name , Null) as Name , Grade , Marks from (
select s.ID , s.Name , s.Marks , g.Grade
from Students as s inner join Grades as g on s.Marks between g.MinMark and g.MaxMark
) as df
order by Grade desc , Name asc , Marks asc
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Piling Up!
You are viewing a single comment's thread. Return to all comments →
most easy code :-
select if(Grade >= 8 , Name , Null) as
Name, Grade , Marks from ( select s.ID , s.Name , s.Marks , g.Grade from Students as s inner join Grades as g on s.Marks between g.MinMark and g.MaxMark ) as df order by Grade desc , Name asc , Marks asc