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.
MS SQL
select case when g.grade < 8 then "null"
else s.Name
end,g.grade,s.Marks from Students as s join Grades as g on g.Min_Mark <= s.Marks and s.Marks <= g.Max_Mark
order by g.grade desc,s.name asc;
The Report
You are viewing a single comment's thread. Return to all comments →
MS SQL select case when g.grade < 8 then "null" else s.Name end,g.grade,s.Marks from Students as s join Grades as g on g.Min_Mark <= s.Marks and s.Marks <= g.Max_Mark order by g.grade desc,s.name asc;
output
Britney 10 95 Heraldo 10 94 Julia 10 96 Kristeen 10 100 Stuart 10 99 Amina 9 89 Christene 9 88 Salma 9 81 Samantha 9 87 Scarlet 9 80 Vivek 9 84 Aamina 8 77 Belvet 8 78 Paige 8 74 Priya 8 76 Priyanka 8 77 null 7 64 null 7 66 null 6 55 null 4 34 null 3 24
Compiler Message Wrong Answer