常用sql：每天统计等

每天统计

select 
year(CREATED_AT) as yearcount,
month(CREATED_AT) as monthcount,
day(CREATED_AT) daycount,
count(1) COUNT1
from 表名
GROUP BY yearcount,monthcount,daycount
ORDER BY COUNT1 desc;