Badly worded question -
Would statements #1 and #2 consistently return the same result set?
How do we define "Same Result" Same result as the other statement? Same result across multiple executions of each statement?
Obviously statement #2 will always return 0 - 5 is greater than 3. DUH. But if you rerun statement #1 (without rerunning the CREATE / INSERT statements), it will always return the same result; just as statement #2 will always return 0.
Sorry, didn't like that question at all. This reminds me of the old style MS certification questions - the answer is open to interpretation of the question.
At least I get a point for this post ...:P