文章目录
题目
代码(7.21 首刷自解)
# Write your MySQL query statement below
select e1.employee_id, e1.name, count(1) reports_count, round(avg(e2.age)) average_age
from employees e1 inner join employees e2
on e2.reports_to is not null
and e1.employee_id = e2.reports_to
group by e2.reports_to
order by e1.employee_id;