mysql 语句统计每天，每月，每年的数据

年统计

select year(ctime),AVG(kpi)
from lead_user_answer

group by year(ctime)

月统计

select year(ctime),month(ctime),AVG(kpi)
from lead_user_answer
group by year(ctime)

, month(ctime)

日统计

select year(ctime),month(ctime),day(ctime),AVG(kpi)
from lead_user_answer
group by year(ctime)
, month(ctime),day(ctime)