SQL. 统计语句

select date_format(`gmt_created`, '%Y-%m-%d') as '时间', count(1) as '日访问量' 
from `yy_access_history` 
where `gmt_created` >'2023-07-01 00:00:00' 
group by date_format(`gmt_created`, '%Y-%m-%d') 
 order by date_format(`gmt_created`, '%Y-%m-%d') desc;



select date_format(`gmt_created`, '%Y-%m') as '月份', count(1) as '月访问' 
from `yy_access_history` 
where `gmt_created` >'2023-01-01 00:00:00'
group by date_format(`gmt_created`, '%Y-%m') 
 order by date_format(`gmt_created`, '%Y-%m') desc;