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.
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?
select
case when g.grade >7 then s.name else 'Null' end as newname
, g.grade
, s.marks
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;
The Report
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?
select case when g.grade >7 then s.name else 'Null' end as newname , g.grade , s.marks 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'.