I don't normally criticise the questions as:
a. This site is free
b. You don't win anything
c. You nearly always learn something even when the question is ambiguous!
But this one is really ambiguous for me as depending on how you read the question all three answers are true:
1. Create the table insert the data once.
Would statement one always return the same answer - Yes, would statement two always return the same answer - Yes
2. Same scenario, but would statement one AND statement two return the same answer - No (Which is the point of the question as beautifully explained!) OK maybe it's too early in the morning and my brain wasn't quite with it as it really couldn't be option 1, but…
3. You run the whole script every time (it was a temp table after all!) - Well as the data could change each time - Undetermined!
So I had a one in three chance (seeing as I nearly always pick the wrong one in a fifty/fifty - I had no chance with a 1 in 3!) of picking the right answer, which of course I didn't!
So c. rules again, as at least I had to think about this one!
And it reminded me of – if you are using parameter values in the where, i.e. BETWEEN @Param1 AND @param2.
Check first if the @Param1 is less than @Param2 (if not swap them round!)