Writing a Question Of The Day–More Notes

Today I wrote another question based on an error message. I included the error message in the question this time and it’s reasonably helpful, but the question text will, depending on how you read it, point you to the one good answer or convince you the answer must be somewhere else. I’m guessing it will turn out to be an easy question because the wrong answers seem like wrong answers if you understand how SQL works. If you don’t, then you will probably get led astray and learn something. I also included more in the answer about how I thought of the question, in part to help them map a question to the real world and in part to see if my giving those kinds of examples I can get them to think “I get error messages all the time, I could write one of these questions”.