Question about CASE statement

Please see the screenshot attached. I wrote specific codes with CASE statement but the Hint shows differently with the exact same result. In Hint solution, wouldn’t a value satisfies more than one statement and gets assigned multiple column names? Does the order of statements under CASE means the priority of assignation?

Thanks for your help in advance!

If you mean assignment, it would appear than only one when can apply and the others are ignored. You could play around with the order and see if the outcome is different. If not, then that would support that notion of only one when clause.