You are viewing a single comment's thread. Return to all comments →
Select s.Name, g.Grade, s.Marks From Students s Join Grades g on s.Marks >= g.Min_Mark and s.Marks <= g.Max_Mark Where g.Grade >= 8
UNION Select NULL, gg.Grade, ss.Marks From Students ss Join Grades gg on ss.Marks >= gg.Min_Mark and ss.Marks <= gg.Max_Mark Where gg.Grade < 8
Order by Grade Desc, Name ASC, Marks Asc
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 s.Name, g.Grade, s.Marks From Students s Join Grades g on s.Marks >= g.Min_Mark and s.Marks <= g.Max_Mark Where g.Grade >= 8
UNION Select NULL, gg.Grade, ss.Marks From Students ss Join Grades gg on ss.Marks >= gg.Min_Mark and ss.Marks <= gg.Max_Mark Where gg.Grade < 8
Order by Grade Desc, Name ASC, Marks Asc