Thanks for the question.
However, I do not quite agree with your answer that the query you provided is 'a bit of a trick question'; I'd rather consider it testing the ability to logically analyze and disect a given query. ;-)
Cool though, that you provided the less complex version to achieve the same result.
Thanks again, nice question,