We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
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
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
New Companies
You are viewing a single comment's thread. Return to all comments →
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