You are viewing a single comment's thread. Return to all comments →
select results.name,results.grade, results.marks from
(select S.name Name, G.grade, S.marks
from Students S inner join grades G
on S.marks between G.Min_Mark and G.Max_Mark
where S.marks>=70
UNION
select NULL Name, Gr.grade, ST.marks
from Students ST inner join grades Gr
on ST.marks between Gr.Min_Mark and Gr.Max_Mark
where ST.marks<=69 ) results order by results.grade DESC,results.name,results.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 →
select results.name,results.grade, results.marks from
(select S.name Name, G.grade, S.marks
from Students S inner join grades G
on S.marks between G.Min_Mark and G.Max_Mark
where S.marks>=70
UNION
select NULL Name, Gr.grade, ST.marks
from Students ST inner join grades Gr
on ST.marks between Gr.Min_Mark and Gr.Max_Mark
where ST.marks<=69 ) results order by results.grade DESC,results.name,results.marks;