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 name, g.grade, s.marks from students s inner join grades g on s.marks between g.min_mark and g.max_mark order by g.grade desc, s.name asc, s.marks asc
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 →
MS SQL Server: