Really a nice question, make me learn more about this basic knowledge.

However, in real case, we really seldom use "Union" and "Union all" together just like the questions. always use any one of it to make the script consistence

anyway, now I am much more clearer about these two commands and the sequence effect