SELECT RPAD(Name, 30) As "BranchName",
RPAD(COUNT(Account.ID), 20) As "AccountsOpened"
FROM Branch, B_e, Employee, E_a, Account
WHERE Branch.ID = BranchID
      AND B_e.EmpID = Employee.ID
      AND Employee.ID = E_a.EmpID
      AND AccID = Account.ID
GROUP BY Name;
