We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT (CASE WHEN Grades.Grade < 8 THEN 'NULL' ELSE Students.Name END ) , Grades.Grade, Students.Marks FROM Students
LEFT JOIN Grades
on Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark
ORDER BY Grades.Grade DESC, Students.Name
The Report
You are viewing a single comment's thread. Return to all comments →
There is no ambiguity
SELECT (CASE WHEN Grades.Grade < 8 THEN 'NULL' ELSE Students.Name END ) , Grades.Grade, Students.Marks FROM Students LEFT JOIN Grades on Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark ORDER BY Grades.Grade DESC, Students.Name