The Report

  • + 1 comment

    This worked for me

    select if(grade<8,null,name) as name, grade, marks from students as s join grades as g on (s.marks between g.min_mark and g.max_mark) order by grade desc,name,marks;