You are viewing a single comment's thread. Return to all comments →
SELECT c.company_code, c.founder, COUNT(DISTINCT e.lead_manager_code) AS lead_managers, COUNT(DISTINCT e.senior_manager_code)AS senior_managers, COUNT(DISTINCT e.manager_code) AS managers, COUNT(DISTINCT e.employee_code) AS employees FROM Company c JOIN Employee e ON e.company_code = c.company_code GROUP BY c.company_code, c.founder ORDER BY c.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 →