I have to laugh,
After seeing all these comments about what should have been implied and what was inferred, I can't tell you the number of times these QotD have been trick questions, trying to 'get you' with slight and small syntax errors or db assumptions, intentionally generating an error message.
Just because someone ran the code and got an error message does not mean the error message was not the correct answer.
In this case, an error message was not option 'D', so I proceeded with the assumption that at least one of the three generated correct results.
Thanks for the question Sudhir. I enjoyed this one.