The Report

SELECT CASE WHEN G.GRADE < 8 THEN NULL ELSE S.NAME
    , G.GRADE
    , S.MARKS
FROM STUDENTS S
    INNER JOIN GRADES G ON S.MARKS BETWEEN G.MIN_MARK AND G.MAX_MARK
ORDER BY G.GRADE DESC, NAME, S.MARKS;