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,
SUBSTRING(c.company_code,2,CHARINDEX('_',c.company_code))
AS com_code ,
c.founder,
COUNT(DISTINCT(lm.lead_manager_code)),
COUNT(DISTINCT(sm.senior_manager_code)),
COUNT(DISTINCT(m.manager_code)),
COUNT(DISTINCT(e.employee_code))
FROM Company c
LEFT JOIN Lead_Manager lm
ON c.company_code = lm.company_code
LEFT JOIN Senior_Manager sm ON c.company_code = sm.company_code
LEFT JOIN Manager m ON c.company_code = m.company_code
LEFT JOIN Employee e ON c.company_code = m.company_code
ORDER BY com_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, SUBSTRING(c.company_code,2,CHARINDEX('_',c.company_code)) AS com_code , c.founder, COUNT(DISTINCT(lm.lead_manager_code)), COUNT(DISTINCT(sm.senior_manager_code)), COUNT(DISTINCT(m.manager_code)), COUNT(DISTINCT(e.employee_code)) FROM Company c LEFT JOIN Lead_Manager lm ON c.company_code = lm.company_code LEFT JOIN Senior_Manager sm ON c.company_code = sm.company_code LEFT JOIN Manager m ON c.company_code = m.company_code LEFT JOIN Employee e ON c.company_code = m.company_code ORDER BY com_code ASC;