The Report

  • + 0 comments

    select case when Grades.grade>=8 then Students.name else null end as name, Grades.grade, Students.marks from Students inner join Grades on Students.marks>=Grades.Min_mark and Students.marks<=Grades.Max_mark order by Grades.grade desc, Students.name asc