You are viewing a single comment's thread. Return to all comments →
Here is my solution that passes the test
SELECT CASE WHEN G.Grade < 8 THEN NULL ELSE S.Name END AS Name, G.Grade, S.Marks FROM STUDENTS AS S, GRADES AS G WHERE S.Marks >= G.Min_Mark AND S.Marks <= G.Max_Mark ORDER BY G.Grade DESC, S.Name ASC;
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 →
Here is my solution that passes the test