You are viewing a single comment's thread. Return to all comments →
this worked for me
(select Name, Grade, Marks from Students, Grades where Marks >= Min_Mark and Marks <= Max_Mark and Grade >=8 )
union
(select null, Grade, Marks from Students, Grades where Marks >= Min_Mark and Marks <= Max_Mark and Grade <8 ) order by Grade desc, Name, Marks;
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
this worked for me
(select Name, Grade, Marks from Students, Grades where Marks >= Min_Mark and Marks <= Max_Mark and Grade >=8 )
union
(select null, Grade, Marks from Students, Grades where Marks >= Min_Mark and Marks <= Max_Mark and Grade <8 ) order by Grade desc, Name, Marks;