Medium - Q3
Anonymous
sql
11/14/2021 4:15 PM
348 B
21
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...