Medium: Question 3
user_0571526250
mysql
3 years ago
177 B
4
Indexable
/*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;
Editor is loading...