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!