SELECT RPAD(Employee.ID, 10) As "EmployeeID",
RPAD(COUNT(Account.ID), 14) As "AccountsOpened"
FROM Employee, E_a, Account
WHERE Employee.ID = EmpID 
      AND AccID = Account.ID
GROUP BY Employee.ID;
