Medium: Question o2

/*Medium question 2: new companies structure */
SELECT COMPANIES.COMPANY_CODE, COMPANIES.FOUNDER, 
count(distinct EMPLOYEES.LEAD_MANAGER_CODE), 
count(distinct EMPLOYEES.SENIOR_MANAGER_CODE), 
count(distinct EMPLOYEES.MANAGER_CODE), 
count(distinct EMPLOYEES.EMPLOYEE_CODE) 
FROM COMPANY COMPANIES
JOIN EMPLOYEE EMPLOYEES ON COMPANIES.COMPANY_CODE = EMPLOYEES.COMPANY_CODE 
GROUP BY COMPANIES.COMPANY_CODE, COMPANIES.FOUNDER 
ORDER BY COMPANIES.COMPANY_CODE ASC;