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.
# ORACLE
SELECT CO.COMPANY_CODE, CO.FOUNDER,
COUNT( DISTINCT(L.LEAD_MANAGER_CODE)) N_O_LEA,
COUNT( DISTINCT(S.SENIOR_MANAGER_CODE)) N_O_SENIO,
COUNT( DISTINCT(M.MANAGER_CODE)) N_O_MANA,
COUNT( DISTINCT(E.EMPLOYEE_CODE)) N_O_EMPLO
FROM COMPANY CO JOIN LEAD_MANAGER L
ON(CO.COMPANY_CODE = L.COMPANY_CODE )
JOIN SENIOR_MANAGER S
ON(CO.COMPANY_CODE = S.COMPANY_CODE)
JOIN MANAGER M
ON(CO.COMPANY_CODE = M.COMPANY_CODE)
JOIN EMPLOYEE E
ON(CO.COMPANY_CODE = E.COMPANY_CODE)
GROUP BY CO.COMPANY_CODE, CO.FOUNDER
ORDER BY CO.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 →
# ORACLE SELECT CO.COMPANY_CODE, CO.FOUNDER, COUNT( DISTINCT(L.LEAD_MANAGER_CODE)) N_O_LEA, COUNT( DISTINCT(S.SENIOR_MANAGER_CODE)) N_O_SENIO, COUNT( DISTINCT(M.MANAGER_CODE)) N_O_MANA, COUNT( DISTINCT(E.EMPLOYEE_CODE)) N_O_EMPLO FROM COMPANY CO JOIN LEAD_MANAGER L ON(CO.COMPANY_CODE = L.COMPANY_CODE ) JOIN SENIOR_MANAGER S ON(CO.COMPANY_CODE = S.COMPANY_CODE) JOIN MANAGER M ON(CO.COMPANY_CODE = M.COMPANY_CODE) JOIN EMPLOYEE E ON(CO.COMPANY_CODE = E.COMPANY_CODE) GROUP BY CO.COMPANY_CODE, CO.FOUNDER ORDER BY CO.COMPANY_CODE ASC;