• Pretty easy question, if you eliminate incorrect answers.

    @b-2 is never used, so the first and the last answer were impossible.

    I knew there wasn't any incorrect syntax with the aliases, so the second answer was also incorrect. So that leaves us only with the arrays of numbers.

    However, as the B column always returns 1, it was pretty easy to deduce the correct answer.

    Nonetheless, great question which incorporated various scenarios. Thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP