Medium - Q3
unknown
sql
3 years ago
259 B
8
Indexable
select case when grades.grade >= 8 then students.name else 'NULL' end, grades.grade, students.marks from students join grades on students.marks >= grades.min_mark and students.marks <= grades.max_mark order by grades.grade desc, students.name, students.marks;
Editor is loading...