You are viewing a single comment's thread. Return to all comments →
In MySQL:
select case when a.grades > 7 then a.name else null end, a.grades, a.marks from (select s.Name, (select g.grade from grades g where s.marks between g.min_mark and g.max_mark) as grades, s.Marks from students s )as a order by a.grades desc, isnull(a.name),a.name, a.marks;
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 →
In MySQL: