• If this is an easy starter for a series of questions that gradually builds up, then it's sort of okay - though probably TOO easy.

    As a stand alone question, I am not excited about it. The use of parentheses in all the queries means that there is no ambiguity anywhere, even for those who don't know the rest of the arithmetic precedence rules (and I would hope that almost everyone would get the question right even if there were no parentheses used in some of the queries).

    Also, why use a blog post as the only reference, when a 5 second Google search would have given you this Books Online link?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/