The Report

  • + 1 comment

    For MySQL Platform

    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;