I have also done the query seperate and used a union all clause and get the
right results, but the employees are listed twice and the counts are all in the
same column instead of two different one named after their alias.