Fabo,

>Every single SELECT can be used alone,
>and therefore it has to have some proper names;

They are not being used alone, they are being aggregated into one common output because of the union.

How you justify calling a column an orange in one case and an apple the next and complain when you get fruit salad as a result is beyond reason.