• Thank you for the question.

    I deduced the result using operator precedence and parsing the input by hand (or head?).

    Typed it into my local, friendly SSMS, and got the same result.

    Although I hadn't really thought about it, the "operator precedence" combined with the "test data might thwart you" nature of this question really made the discussion pay off.

    Keep your databases clean.