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(Lead_Manager.lead_manager_code), COUNT(Senior_Manager.senior_manager_code), COUNT(Manager.manager_code), COUNT(Employee.employee_code)
FROM
Company, Lead_Manager, Senior_Manager, Manager, Employee
WHERE
Company.company_code = Lead_Manager.company_code
AND Company.company_code = Senior_MAnager.company_code
AND Company.company_code = Manager.company_code
AND Company.company_code= Employee.company_code
AND Lead_Manager.company_code = Senior_Manager.company_code
AND Lead_Manager.company_code = Manager.company_code
AND Lead_Manager.company_code = Employee.company_code
AND Senior_Manager.company_code = Manager.company_code
AND Senior_Manager.company_code = Employee.company_code
AND Manager.company_code = Employee.company_code
GROUP BY Company.company_code
ORDER BY 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 →
Can Someone please tell me why this is wrong ?
SELECT Company.company_code, Company.founder, COUNT(Lead_Manager.lead_manager_code), COUNT(Senior_Manager.senior_manager_code), COUNT(Manager.manager_code), COUNT(Employee.employee_code) FROM Company, Lead_Manager, Senior_Manager, Manager, Employee WHERE Company.company_code = Lead_Manager.company_code AND Company.company_code = Senior_MAnager.company_code AND Company.company_code = Manager.company_code AND Company.company_code= Employee.company_code AND Lead_Manager.company_code = Senior_Manager.company_code AND Lead_Manager.company_code = Manager.company_code AND Lead_Manager.company_code = Employee.company_code AND Senior_Manager.company_code = Manager.company_code AND Senior_Manager.company_code = Employee.company_code AND Manager.company_code = Employee.company_code GROUP BY Company.company_code ORDER BY company_code;