You are viewing a single comment's thread. Return to all comments →
For Oracle
SELECT CASE WHEN STUDENTS.MARKS >70 THEN STUDENTS.NAME ELSE 'NULL' END AS NAME, GRADES.GRADE, STUDENTS.MARKS FROM STUDENTS JOIN GRADES ON STUDENTS.MARKS BETWEEN GRADES.MIN_MARK AND GRADES.MAX_MARK ORDER BY GRADES.GRADE DESC, STUDENTS.NAME ASC;
Seems like cookies are disabled on this browser, please enable them to open this website
The Report
You are viewing a single comment's thread. Return to all comments →
For Oracle