Untitled

 avatar
user_1196610317
mysql
2 years ago
270 B
0
Indexable
Never
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;