在 MySQL 中进行查询以计算成员

Question

使用平均年龄计数编写 Mysql 查询

Answer 1

尝试以下操作

select
ReportsTo,
count(*) as Members,
avg(age) as Average_Age
from yourTable
where ReportsTo is not null
group by
ReportsTo

Answer 2

这实际上很容易。这可能对你有用！

SELECT ReportsTo, COUNT(Members) as Members, AVG(Age) as average FROM table GROUP BY ReportsTo ORDER BY ReportsTo