• 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.