q3_med
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...
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;