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.
Loading...
  1. Practice
  2. SQL
  3. Basic Join
  4. The Report
  5. Discussions

The Report

  • qwpurdue + 1 comment

    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;
    • dalton_478 + 0 comments

      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.