Problem: 1731. 每位经理的下属员工数量
Code
select m.Employee_id, m.name,count(*) reports_count,
round(avg(e.age),0) average_age
from Employees e
join Employees m
on e.reports_to = m.Employee_id
group by m.Employee_id
order by m.Employee_id
Problem: 1731. 每位经理的下属员工数量
select m.Employee_id, m.name,count(*) reports_count,
round(avg(e.age),0) average_age
from Employees e
join Employees m
on e.reports_to = m.Employee_id
group by m.Employee_id
order by m.Employee_id