q3_med
user_0537875676
mysql
11/14/2021 9:52 AM
204 B
12
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;