The Report

  • + 0 comments

    SELECT CASE WHEN g.Grade < 8 THEN NULL ELSE s.Name END AS NAME, g.Grade, s.Marks FROM Students s JOIN Grades ON s.Marks BETWEEN g.Min_Mark AND g.Mark_Mark ORDER BY g.Grade DESC, CASE WHEN g.Grade >= 8 THEN s.Name ELSE NULL END ASC, CASE WHEN g.Grade < 8 THEN s.Marks ELSE NULL END ASC;