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, C.founder,
count(distinct E.lead_manager_code),
count( distinct E.senior_manager_code),
count(distinct E.manager_code),
count( distinct E.employee_code)
from Company as C
join Employee as E
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 →
select C.company_code, C.founder, count(distinct E.lead_manager_code), count( distinct E.senior_manager_code), count(distinct E.manager_code), count( distinct E.employee_code) from Company as C join Employee as E on C.company_code=E.company_code group by C.company_code, C.founder order by C.company_code Asc;