Q3 Med
Anonymous
mysql
11/20/2021 6:16 AM
292 B
23
Indexable
SELECT (CASE g.grade>=8 WHEN TRUE THEN s.name
ELSE NULL END), g.grade, s.marks FROM students s
INNER JOIN grades g ON s.marks BETWEEN min_mark AND max_mark
ORDER BY g.grade DESC, s.name, s.marks;Editor is loading...