The_Number_of_Employees_Which_Report_to_Each_Employee.sql

select e1.employee_id, e1.name, count(e2.employee_id) as reports_count,
     round(avg(e2.age)) as average_age
     from employees e1 join employees e2 on e1.employee_id = e2.reports_to
group by e1.employee_id, e1.name
order by e1.employee_id




--Rakshit Gupta