@Craig: Answer A has an ORDER BY but invalid syntax.

The problem in general from my point of view:

There's a company looking for someone with decent SQL skills since they obviously don't have anybody at the team yet. Or they're trying to ask a bunch of trick questions just for the fun of it, and missed to include the fun part.

But if you (JagWalia) cannot spot the errors in the questions/answers and provide a reason why those are wrong, you're probably not the one they're looking for. The company seems to look for someone to teach, not to learn...