sql查询，日期字段包含年月日时分秒，如何按日统计

1、原数据

2、date_format格式化为年月日

select sku_id,trade_time,date_format(trade_time,“%y-%m-%d”) as day from aaa
aaa表示表名
查询结果

3、按照日统计

select date_format(trade_time,“%y-%m-%d”) as day,count(*) as count from aaa group by day order by count DESC
查询结果