Untitled

 avatar
user_1196610317
mysql
3 years ago
270 B
2
Indexable
SELECT Name, Grade, Marks FROM Students, Grades 
WHERE Marks BETWEEN Min_Mark AND Max_Mark AND Grade>=8 
ORDER BY Grade desc, Name;

SELECT null, Grade, Marks FROM Students, Grades 
WHERE Marks BETWEEN Min_Mark AND Max_Mark AND Grade<8 
ORDER BY Grade desc, Name, Marks;
Editor is loading...