why this doesn't work? I get syntax error all the time with mysql

select company_code, founder, count(distinct *) over (partition by company_code) as c1, count(distinct *) over (partition by lead_manager_code) as c2, count(distinct *) over (partition by senior_manager_code) as c3, count(distinct *) over (partition by manager_code) as c4 from employee join company using (company_code) order by company_code asc

**SELECT Company.company_code ,company.founder , count(distinct Lead_Manager.lead_manager_code), count(distinct Senior_Manager.senior_manager_code), count(distinct Manager.manager_code), count(distinct Employee.employee_code) FROM Company INNER JOIN Lead_Manager ON Company.company_code=Lead_Manager.company_code INNER JOIN Senior_Manager ON Company.company_code=Senior_Manager.company_code INNER JOIN Manager ON Company.company_code =Manager.company_code INNER JOIN Employee ON **Company.company_code=Employee.company_code GROUP BY Company.company_code ,company.founder ORDER BY company_code ASC ;

SELECT comp.company_code, comp.founder, (SELECT COUNT() FROM lead_manager WHERE company_code = comp.company_code) AS total_leads, (SELECT COUNT() FROM senior_manager WHERE company_code = comp.company_code) AS total_seniors, (SELECT COUNT() FROM manager WHERE company_code = comp.company_code) AS total_managers, (SELECT COUNT() FROM employee WHERE company_code = comp.company_code) AS total_employees FROM company AS comp ORDER BY comp.company_code ASC;

For MS SQL SErver

SELECT c.company_code, c.founder, count(distinct l.lead_manager_code), count(distinct s.Senior_Manager_code), count(distinct m.Manager_code), count(distinct e.Employee_code) from company c JOIN lead_manager l on l.company_code = c.company_code JOIN Senior_Manager s on l.lead_manager_code = s.lead_manager_code join Manager m on s.Senior_Manager_code = m.Senior_Manager_code JOIN Employee e on m.Manager_code = e.Manager_code

group by c.company_code, c.founder order by c.company_code

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 inner join employee on company.company_code=employee.company_code

group by company.company_code, company.founder order by company.company_code;