Ally Financial Interview Question

Question on SQL query Unions