q3_med

 avatar
user_0537875676
mysql
3 years ago
151 B
5
Indexable
SELECT  IF (Grade <= 7, NULL, Name), Grade, Marks
FROM STUDENTS
INNER JOIN GRADES
ON Marks BETWEEN Min_Mark AND Max_Mark
ORDER BY Grade DESC, Name;
Editor is loading...