Untitled
user_9914919852
plain_text
4 years ago
272 B
4
Indexable
SELECT CASE
WHEN Grades.Grade > 7 THEN Name ELSE NULL END
AS LabelName, Grades.Grade, Students.Marks FROM Students
INNER JOIN Grades ON Grades.Min_Mark <= Students.Marks AND Grades.Max_Mark >= Students.Marks
ORDER BY Grades.Grade DESC, LabelName, MarksEditor is loading...