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.
select
c.company_code as company_code,
c.founder as founder,
count(distinct lead_manager_code) as lead_managers ,
count(distinct senior_manager_code) as senior_managers,
count(distinct manager_code) as managers,
count(distinct employee_code) as employees
from employee e
left join company c
on c.company_code=e.company_code
group by c.company_code,c.founder
order by c.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 →
My Submission :
select c.company_code as company_code, c.founder as founder, count(distinct lead_manager_code) as lead_managers , count(distinct senior_manager_code) as senior_managers, count(distinct manager_code) as managers, count(distinct employee_code) as employees from employee e left join company c on c.company_code=e.company_code group by c.company_code,c.founder order by c.company_code asc;