You are viewing a single comment's thread. Return to all comments →
SELECT CASE WHEN grades.grade >= 8 THEN students.name ELSE NULL END AS "toppers_list", grades.grade, students.marks FROM students JOIN grades ON students.marks BETWEEN grades.min_mark AND grades.max_mark ORDER BY grades.grade DESC, toppers_list, students.marks;
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
For MySQL Platform