The Report

  • + 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;