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.
MS SQL but so long.
select C.Company_code
,C.founder
,L.C_L
,S.C_S
,M.C_M
,E.C_E
from Company C
left join
(
select count(distinct L.lead_manager_code ) C_L
,L.Company_code
from Lead_Manager L
group by L.Company_code
)L
on L.Company_code = C.Company_code
left join
(
select count(distinct S.senior_manager_code) C_S
,S.Company_code
from Senior_Manager S
group by S.Company_code
)S
on S.Company_code = C.Company_code
left join
(
select count(distinct M.manager_code) C_M
,M.Company_code
from Manager M
group by M.Company_code
)M
on M.Company_code = C.Company_code
left join
(
select count(distinct E.Employee_code) C_E
,E.Company_code
from Employee E
group by E.Company_code
)E
on E.Company_code = C.Company_code
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 →
MS SQL but so long. select C.Company_code ,C.founder ,L.C_L ,S.C_S ,M.C_M ,E.C_E from Company C left join ( select count(distinct L.lead_manager_code ) C_L ,L.Company_code from Lead_Manager L group by L.Company_code )L on L.Company_code = C.Company_code left join ( select count(distinct S.senior_manager_code) C_S ,S.Company_code from Senior_Manager S group by S.Company_code )S on S.Company_code = C.Company_code left join ( select count(distinct M.manager_code) C_M ,M.Company_code from Manager M group by M.Company_code )M on M.Company_code = C.Company_code left join ( select count(distinct E.Employee_code) C_E ,E.Company_code from Employee E group by E.Company_code )E on E.Company_code = C.Company_code order by C.Company_code asc