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 L.LEAD_MANAGER_CODE),
COUNT(DISTINCT S.SENIOR_MANAGER_CODE),
COUNT(DISTINCT M.MANAGER_CODE),
COUNT(DISTINCT E.EMPLOYEE_CODE)
FROM
COMPANY C INNER JOIN LEAD_MANAGER L
ON
C.COMPANY_CODE=L.COMPANY_CODE
INNER JOIN SENIOR_MANAGER S
ON
L.COMPANY_CODE=S.COMPANY_CODE
INNER JOIN MANAGER M
ON
S.COMPANY_CODE=M.COMPANY_CODE
INNER JOIN EMPLOYEE E
ON
M.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 L.LEAD_MANAGER_CODE), COUNT(DISTINCT S.SENIOR_MANAGER_CODE), COUNT(DISTINCT M.MANAGER_CODE), COUNT(DISTINCT E.EMPLOYEE_CODE) FROM COMPANY C INNER JOIN LEAD_MANAGER L ON C.COMPANY_CODE=L.COMPANY_CODE INNER JOIN SENIOR_MANAGER S ON L.COMPANY_CODE=S.COMPANY_CODE INNER JOIN MANAGER M ON S.COMPANY_CODE=M.COMPANY_CODE INNER JOIN EMPLOYEE E ON M.COMPANY_CODE=E.COMPANY_CODE GROUP BY C.COMPANY_CODE,C.FOUNDER ORDER BY C.COMPANY_CODE ASC;