Ally Financial interview question

Question on SQL query Unions