The Report

  • + 0 comments

    my solution i hope it pretty easy to understand:

    select Name= case when grade<8 then null else name end , Grade, Marks from students a inner join grades b on a.marks between b.min_mark and b.max_mark order by case when grade>=8 then grade end desc,name asc, case when grade<=7 then grade end desc,marks asc