You are viewing a single comment's thread. Return to all comments →
Here is Oracle solution from my HackerrankPractice repository:
CASE WHEN G.Grade > 7 THEN S.Name ELSE 'NULL' END AS NameOrNull
FROM Students S
JOIN Grades G ON S.Marks BETWEEN G.Min_Mark AND G.Max_Mark
ORDER BY G.Grade DESC, NameOrNull ASC, S.Marks ASC;
Feel free to ask if you have any questions :)
Hi, I have almost exact the same code as yours but I did not pass. I could not find a reason. The answers are exactly the same. Could you help me to see which part I did wrong?
case when g.grade >7 then s.name else 'Null' end as newname
from students s
join grades g on s.marks between g.min_mark and g.max_mark
order by g.grade desc, newname asc, s.marks asc;
Updates: I figured it out now. I use 'Null' not 'NULL'.