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 t2.Grade >= 8 THEN t1.Name ELSE NULL END , t2.Grade ,t1.marks from Students as t1 join Grades as t2 where t1.marks between t2.Min_Mark and t2.Max_Mark order by t2.grade desc, t1.Name
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 →
SELECT CASE WHEN t2.Grade >= 8 THEN t1.Name ELSE NULL END , t2.Grade ,t1.marks from Students as t1 join Grades as t2 where t1.marks between t2.Min_Mark and t2.Max_Mark order by t2.grade desc, t1.Name