MySQL按日期统计

orders表如下：

执行如下语句：

select DATE_FORMAT(create_at,'%Y-%m-%d') as day,SUM(count) as  count from orders GROUP BY day;

结果如下：