q3_med

 avatar
user_0537875676
mysql
2 years ago
151 B
3
Indexable
Never
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;