207502

SELECT EMPLOYEE.company_code, COMPANY.founder, COUNT(DISTINCT EMPLOYEE.lead_manager_code), COUNT(DISTINCT EMPLOYEE.senior_manager_code), COUNT(DISTINCT EMPLOYEE.manager_code),COUNT(DISTINCT EMPLOYEE.employee_code) FROM EMPLOYEE
JOIN COMPANY ON EMPLOYEE.company_code = COMPANY.company_code
GROUP BY EMPLOYEE.company_code, COMPANY.founder
ORDER BY EMPLOYEE.company_code;