Query Questions
Find the total count of employees under each Manager? select empname ,( select count (*) from employee where reporterid = e . empid ) from employee e select e1 . empid , e1 . empname , count (*) from employee e1 inner join employee e2 on e1 . empid = e2 . reporterid group by e1 . empid , e1 . empname ;