The Report

  • + 60 comments

    Simple MySQL solution

    SELECT IF(GRADE < 8, NULL, NAME), GRADE, MARKS
    FROM STUDENTS JOIN GRADES
    WHERE MARKS BETWEEN MIN_MARK AND MAX_MARK
    ORDER BY GRADE DESC, NAME