join

The Report - BETWEEN 범위 조건으로 JOIN 하기 report NOT : Names of those students who received a grade lower than 8. → if the grade is lower than 8, use "NULL" Ordering by grade in descending, than alphabetically More than one student with the same grade (1-7), ordering by marks in ascending order SELECT CASE WHEN G.grade >= 8 THEN S.Name ELSE NULL END AS Name, G.grade, S.Marks FROM Students S, Grades G..