Medium: Question 3

 avatar
user_0571526250
mysql
2 years ago
177 B
1
Indexable
Never
/*medium q3*/
SELECT IF(GRADE > 7, NAME, NULL), GRADE, MARKS
FROM STUDENTS INNER JOIN GRADES
WHERE MARKS BETWEEN Min_MARK AND Max_MARK
ORDER BY GRADE DESC, NAME ASC, MARKS ASC;