Untitled
Anonymous
plain_text
11/25/2021 4:31 PM
344 B
26
Indexable
SELECT
CASE
WHEN grades.grade>7 THEN students.name
ELSE NULL
END
AS name, grades.grade, students.marks FROM students JOIN grades ON students.marks
BETWEEN grades.min_mark AND grades.max_mark ORDER BY grades.grade DESC, name ASC;Editor is loading...