Question 3 (The Report)

 avatar
user_6227789376
mysql
2 years ago
248 B
0
Indexable
Never
-- Medium
-- Question 3 (The Report):


SELECT IF(grades.grade>=8, students.name, NULL),grades.grade, students.marks

FROM grades, students WHERE students.marks BETWEEN grades.min_mark AND grades.max_mark

ORDER BY grades.grade DESC, students.name;