1、按照时间段统计
select count(1) from t_table t
where t.CREATION_TIME> '2021-01-01 00:00:00'
and t.CREATION_TIME < '2022-12-31 23:59:59'
and t.W_ID="8aaa4d8f718389590171957ddd9a061a";
2、按月分组统计
select date_format(CREATION_TIME, '%Y-%m') moth, count(*) cunt
from t_table where W_ID="8aaa9f856"
and CREATION_TIME> '2021-01-01 00:00:00'
group by date_format(CREATION_TIME, '%Y-%m');