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 Company.company_code ,company.founder ,
count(distinct Lead_Manager.lead_manager_code),
count(distinct Senior_Manager.senior_manager_code),
count(distinct Manager.manager_code),
count(distinct Employee.employee_code) FROM Company
INNER JOIN Lead_Manager ON Company.company_code=Lead_Manager.company_code
INNER JOIN Senior_Manager ON Company.company_code=Senior_Manager.company_code
INNER JOIN Manager ON Company.company_code =Manager.company_code
INNER JOIN Employee ON **Company.company_code=Employee.company_code
GROUP BY Company.company_code ,company.founder
ORDER BY 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 Company.company_code ,company.founder , count(distinct Lead_Manager.lead_manager_code), count(distinct Senior_Manager.senior_manager_code), count(distinct Manager.manager_code), count(distinct Employee.employee_code) FROM Company INNER JOIN Lead_Manager ON Company.company_code=Lead_Manager.company_code INNER JOIN Senior_Manager ON Company.company_code=Senior_Manager.company_code INNER JOIN Manager ON Company.company_code =Manager.company_code INNER JOIN Employee ON **Company.company_code=Employee.company_code GROUP BY Company.company_code ,company.founder ORDER BY company_code ASC ;