Medium - Q3

mail@pastecode.io avatar
unknown
sql
2 years ago
259 B
6
Indexable
Never
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;