Lousy question, if you ask me ....

It encourages us to copy and paste the question into the query editor in order to avoid little misreadings. I don't think this is the appropriate way to answer questions which are supposed to teach us something.

I don't have AdventureWorks installed on any instance, so, after concluding that it should be "return all records" I tried a similar query on our own contacts table, typing the statement manually and (of course!) not making such a mistake!