Untitled
unknown
plain_text
4 years ago
257 B
9
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...