The Report

  • + 1 comment

    There is no ambiguity

    SELECT (CASE WHEN Grades.Grade < 8 THEN 'NULL' ELSE Students.Name END ) , Grades.Grade, Students.Marks FROM Students LEFT JOIN Grades on Students.Marks BETWEEN Grades.Min_Mark AND Grades.Max_Mark ORDER BY Grades.Grade DESC, Students.Name