SELECT
    E.company_code,
    C.founder,
    E.c_lead_manager_code,
    E.c_senior_manager_code,
    E.c_manager_code,
    E.c_employee_code
FROM (
    SELECT
        company_code,
        COUNT(DISTINCT employee_code) AS c_employee_code,
        COUNT(DISTINCT manager_code) AS c_manager_code,
        COUNT(DISTINCT senior_manager_code) AS c_senior_manager_code,
        COUNT(DISTINCT lead_manager_code) AS c_lead_manager_code
    FROM Employee
    GROUP BY company_code
) E JOIN Company C ON E.company_code = C.company_code
ORDER BY E.company_code ASC;