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.
Oracle SQL using With, Single Join & a Group by Clause
With CTE as
(
Select C.Company_Code, C.FOunder, E.employee_code, E.manager_code, E.senior_manager_code, E.lead_manager_code
From Company C
Left Join Employee E
On C.Company_code = E.Company_code
)
Select Company_Code, Founder, Count(Distinct(Lead_Manager_Code)), Count(Distinct(senior_manager_code)),
Count(Distinct(manager_code)), Count(Distinct(employee_code))
From CTE
Group by Company_Code, Founder
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 →
Oracle SQL using With, Single Join & a Group by Clause
With CTE as ( Select C.Company_Code, C.FOunder, E.employee_code, E.manager_code, E.senior_manager_code, E.lead_manager_code From Company C Left Join Employee E On C.Company_code = E.Company_code ) Select Company_Code, Founder, Count(Distinct(Lead_Manager_Code)), Count(Distinct(senior_manager_code)), Count(Distinct(manager_code)), Count(Distinct(employee_code)) From CTE Group by Company_Code, Founder Order by Company_Code;