Medium 3
Manishyadav514
mysql
3 years ago
171 B
2
Indexable
SELECT IF(GRADE > 7, NAME, NULL), GRADE, MARKS FROM STUDENTS INNER JOIN GRADES WHERE MARKS >= MIN_MARK AND MARKS <= MAX_MARK ORDER BY GRADE DESC, NAME ASC, MARKS ASC;
Editor is loading...
SELECT IF(GRADE > 7, NAME, NULL), GRADE, MARKS FROM STUDENTS INNER JOIN GRADES WHERE MARKS >= MIN_MARK AND MARKS <= MAX_MARK ORDER BY GRADE DESC, NAME ASC, MARKS ASC;