The Report

  • + 0 comments

    SPOILERS ALERT

    SELECT 
    CASE WHEN S.MARKS<70 THEN "NULL"
    ELSE S.NAME
    END AS NAME,
    M.GRADE,
    S.MARKS 
    FROM STUDENTS S,GRADES M
    WHERE S.MARKS BETWEEN M.MIN_MARK AND M.MAX_MARK
    ORDER BY M.GRADE DESC,S.NAME ASC, S.MARKS ASC;