Epic conclusion & human behavior analysis
Here are the standings as of this morning after 941 attempts :
"It depends" (7%) is the classic answer in sql server but it just cannot apply here. The case expression is deterministic therefore it'll never change given the same parameters.
1 - 05% That answer is just impossible. The case statement would return 3 rows
2 - 04% That answer is just impossible. The case statement would return 3 rows
5 - 51% You ran the code and/or didn't understand the question and/or didn't understand the case filter
3 - 09% Yes for the case filter but you missed the extra union all. Thanks for trying without running the code and successfully decoding the case expression.
0 - 25% Congrats (or you ran the code because you had no idea). Since 51% of you ran the code and still managed to get it wrong I'll assume that the real amount of correct answers is closer to ±12%
Thank you all for participating and keep your stories coming.