grade-of-marks.sql

/* Reporting student grade with particular request */

/* =================== */

SELECT IF(g.grade<8, NULL, s.name), g.grade, s.marks
FROM students AS s JOIN grades AS g ON (s.marks BETWEEN g.min_mark AND g.max_mark)
ORDER BY g.grade DESC, s.marks;