mysql - 在mysql中进行查询以计算成员

Question

编写具有平均年龄计数的 Mysql 查询

标签： mysqlsql

Answer 1

尝试以下

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