Question 3 (The Report)

-- Medium
-- Question 3 (The Report):


SELECT IF(grades.grade>=8, students.name, NULL),grades.grade, students.marks

FROM grades, students WHERE students.marks BETWEEN grades.min_mark AND grades.max_mark

ORDER BY grades.grade DESC, students.name;