Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
370 B
1
Indexable
Never
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;