• Interesting question. Highlights the features of two clauses- UNION & ORDER BY

    but the phrasing of the question was kind of misleading. That has caused lots of folks to skip the second answer. I agree with Hugo Kornelis that the question could have been phrased a little more explicitly.