Untitled

SELECT company_code, founder,
(SELECT COUNT(DISTINCT lead_manager_code) FROM lead_manager WHERE company_code = c.company_code),
(SELECT COUNT(DISTINCT senior_manager_code) FROM SENIOR_MANAGER WHERE company_code = C.company_code),
(SELECT COUNT(DISTINCT MANAGER_CODE) FROM MANAGER WHERE company_code = C.company_code),
(SELECT COUNT(DISTINCT EMPLOYEE_CODE) FROM EMPLOYEE WHERE company_code = C.company_code)
FROM COMPANY C
ORDER BY company_code;