You are viewing a single comment's thread. Return to all comments →
work if case NULL insted of null
select case when g.grade < 8 then "NULL"
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;