I am not aliasing the columns in the order by clause because it is being applied to the results of the union. I have tried adding aliases to all of...