You are viewing a single comment's thread. Return to all comments →
Here is my solution that passes the test
WHEN G.Grade < 8 THEN NULL
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;
The way the problem is worded today this should not pass anymore. The secondary index of s.Name would fail since we are to sort the grades below 8 by the marks.