You are viewing a single comment's thread. Return to all comments →
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 C.company_code = S.company_code JOIN Manager M on C.company_code = M.company_code JOIN Employee E on C.company_code = E.company_code GROUP BY C.company_code, C.FOUNDER ORDER BY company_code ASC;
Seems like cookies are disabled on this browser, please enable them to open this website
New Companies
You are viewing a single comment's thread. Return to all comments →