The Report

  • + 1 comment

    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;