• Wow, this is so ridiculous. The referenced BOL page clearly states:

    No column reference pulls data from multiple rows

    The answer, however includes the opposite and still claims it as a correct option. As a matter of fact even the wording of all listed options matches the BOL word by word except it does not include the word NO for the multiple rows option.

    Oleg