You are viewing a single comment's thread. Return to all comments →
MS SQL SERVER
select case when b.grade <8 then 'NULL' else a.name end as name, b.grade, a.marks from students a join grades b on a.marks >= b.min_mark and a.marks <= b.max_mark order by b.grade desc, a.name 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