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.
where emp.company_code = mgr.company_code AND
mgr.company_code = srMgr.company_code AND
srMgr.company_code = leadMgr.company_code AND
leadMgr.company_code = comp.company_code
group by comp.company_code
comp.company_code
comp.company_code, comp.founder
order by comp.company_code
comp.company_code
comp.company_code;
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 →
yes this also works ,see my query below
SELECT comp.company_code comp.company_code comp.company_code, comp.founder, COUNT(Distinct leadMgr.lead_manager_code), COUNT(Distinct srMgr.senior_manager_code), COUNT(Distinct mgr.manager_code), COUNT(Distinct emp.employee_code) from Employee emp, Manager mgr, Senior_Manager srMgr, Lead_Manager leadMgr , Company comp
where emp.company_code = mgr.company_code AND mgr.company_code = srMgr.company_code AND srMgr.company_code = leadMgr.company_code AND leadMgr.company_code = comp.company_code
group by comp.company_code comp.company_code comp.company_code, comp.founder order by comp.company_code comp.company_code comp.company_code;