We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT
CASE WHEN b.GRADE > 7 THEN a.NAME
ELSE 'NULL'
END NAME, b.GRADE, a.MARKS
FROM STUDENTS a
JOIN GRADES b
on a.MARKS BETWEEN b.MIN_MARK AND b.MAX_MARK
ORDER BY b.GRADE DESC, a.NAME ASC;
Cookie support is required to access HackerRank
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 →
SELECT CASE WHEN b.GRADE > 7 THEN a.NAME ELSE 'NULL' END NAME, b.GRADE, a.MARKS FROM STUDENTS a JOIN GRADES b on a.MARKS BETWEEN b.MIN_MARK AND b.MAX_MARK ORDER BY b.GRADE DESC, a.NAME ASC;