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.
Company.company_code,
founder,
COUNT(DISTINCT Lead_Manager.lead_manager_code) AS LM,
COUNT(DISTINCT Senior_Manager.senior_manager_code) AS SM,
COUNT(DISTINCT Manager.manager_code) AS M,
COUNT(DISTINCT Employee.employee_code) AS E
FROM Company
LEFT JOIN Lead_Manager
ON Company.company_code = Lead_Manager.company_code
LEFT JOIN Senior_Manager
ON Lead_Manager.lead_manager_code = Senior_Manager.lead_manager_code
LEFT JOIN Manager
ON Senior_Manager.senior_manager_code = Manager.senior_manager_code
LEFT JOIN Employee
ON Manager.manager_code = Employee.manager_code
GROUP BY Company.company_code, founder
ORDER BY Company.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
FROM Company
LEFT JOIN Lead_Manager ON Company.company_code = Lead_Manager.company_code
LEFT JOIN Senior_Manager ON Lead_Manager.lead_manager_code = Senior_Manager.lead_manager_code
LEFT JOIN Manager ON Senior_Manager.senior_manager_code = Manager.senior_manager_code LEFT JOIN Employee ON Manager.manager_code = Employee.manager_code GROUP BY Company.company_code, founder ORDER BY Company.company_code ASC;