Query Strategy for this please?

Question

There are two tables, AccountsOpen and AccountsClosed, which keeps track of which employee has openedand closedeach account

AccountsOpen

  EmployeeID (int)

  AccountID (int)

 

AccountsClosed

  EmployeeID (int)

  AccountD (int)

If an employee closes an account they get 1 point

If no one closes an account, the employee that opens the account gets 1 point

  

Answer 1

Run this query:

select EmployeeID, sum(points)
from 
(select EmployeeID, count(*) as points
from AccounsOpen
group by EmployeeID
union
select EmployeeID, count(*) as points
from AccountsClosed
group by EmployeeID) t
group by EmployeeID