New Companies

SELECT c.company_code, c.founder, COUNT(DISTINCT(l.lead_manager_code)), COUNT(DISTINCT(s.senior_manager_code)), COUNT(DISTINCT(m.manager_code)), COUNT(DISTINCT(e.employee_code)) FROM Company c JOIN Lead_Manager l ON c.company_code = l.company_code JOIN Senior_Manager s ON l.lead_manager_code = s.lead_manager_code JOIN Manager m ON s.senior_manager_code = m.senior_manager_code JOIN Employee e ON m.manager_code = e.manager_code GROUP BY 1, 2 ORDER BY c.company_code ;

C1 Angela 1 2 5 13 C10 Earl 1 1 2 3 C100 Aaron 1 2 4 10 C11 Robert 1 1 1 1 C12 Amy 1 2 6 14

SELECT c.company_code, c.founder, COUNT(DISTINCT(l.lead_manager_code)), COUNT(DISTINCT(s.senior_manager_code)), COUNT(DISTINCT(m.manager_code)), COUNT(DISTINCT(e.employee_code)) FROM Company c LEFT JOIN Lead_Manager l ON c.company_code = l.company_code LEFT JOIN Senior_Manager s ON l.lead_manager_code = s.lead_manager_code LEFT JOIN Manager m ON s.senior_manager_code = m.senior_manager_code LEFT JOIN Employee e ON m.manager_code = e.manager_code GROUP BY 1, 2 ORDER BY c.company_code ;