Untitled

SELECT company.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 company JOIN employee ON company.company_code = employee.company_code GROUP BY company.company_code,company.founder ORDER BY company.company_code ASC;