was about to ask if there was any specific reason to mention SQL 2008...
As far as I can see, there wasn't. Semicolonms in subqueries have never been and will never be correct syntax.
The title of the question, mentioning a SQL Server version, mentioning default install, mentioning "the default Northwind database", and even the answers options - these factors all appear to be designed to drag our attention away from a syntax check toward an inspection of the functionality of the query. That gives me the feeling that the author of the question tried hard to minimize the correct answer ratio instead of concentrating on making the question a learning experience.
I am uncertain if this is a good question or not. The point was to error-check. We see that kind of mistake quite a bit in the forums (syntax errors - not necessarily a ";"). I think it helps to reinforce the need to closely evaluate the code - especially since many of us are trying to help others or even help ourselves to get better.
Sure. But for questions posed in forums, the quesrtion submitter usually provides a copy of the code that you can copy/paste and then try yourself, and indicates in the question that there is some syntax error he/she can't figure out. They don't try actively try to hide the fact that there's asyntax error.
This was my first attempt at a QoD so my appologies if it was not up to par. I look forward to submitting more as I come accross various SQL puzzles in my daily work activities.
I know it takes a lot of time and effort to submit a question - and above all, a lot of couurage to face the feedback that will follow. I am glad that, in spite of the harsh critisicm given here (including mine), you have decided not to throw the towel, but to continue submitting questions. Creating questions is a learning experience in its own way. You'll see that your questions (and the feedback) will improve over time. (Allthough with this crowd, you'll probably never submit a question that everyone cheers for:-D)
Thanks for your effort, and I'm lookiing forward to your next contribution.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis