You are viewing a single comment's thread. Return to all comments →
SELECT CASE WHEN G.Grade < 8 Then 'NULL' ELSE S.Name END as Names, G.Grade, S.Marks
FROM Students as S Join Grades as G ON S.Marks between G.Min_Mark and G.Max_Mark
ORDER BY G.Grade DESC, S.Name ASC, S.Marks DESC;
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 CASE WHEN G.Grade < 8 Then 'NULL' ELSE S.Name END as Names, G.Grade, S.Marks
FROM Students as S Join Grades as G ON S.Marks between G.Min_Mark and G.Max_Mark
ORDER BY G.Grade DESC, S.Name ASC, S.Marks DESC;