1731. The Number of Employees Which Report to Each Employee.md

1731. The Number of Employees Which Report to Each Employee

Question Link

Solution

# Write your MySQL query statement below
select e1.employee_id, e1.name, count(*) reports_count, round(avg(e2.age), 0) average_age from Employees e1 join Employees e2
on e1.employee_id=e2.reports_to group by e2.reports_to order by e1.employee_id

• 2024.06.04