You are viewing a single comment's thread. Return to all comments →
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'.