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 Grade < 8 THEN NULL
ELSE Name
END as Name, Grade, Marks
FROM Students
JOIN Grades
On Marks BETWEEN Min_Mark AND Max_Mark
ORDER BY Grade DESC, Name, Marks;
The Report
You are viewing a single comment's thread. Return to all comments →
MS SQL SERVER Solution
SELECT CASE WHEN Grade < 8 THEN NULL ELSE Name END as Name, Grade, Marks FROM Students JOIN Grades On Marks BETWEEN Min_Mark AND Max_Mark ORDER BY Grade DESC, Name, Marks;