the-report.sql

https://www.hackerrank.com/challenges/the-report

SELECT CASE WHEN G.Grade > 7 THEN S.Name ELSE NULL END, G.Grade , S.Marks FROM Students AS S INNER JOIN Grades AS G ON S.Marks >= G.Min_Mark AND S.Marks <= G.Max_Mark ORDER BY Grade DESC,Name,Marks;