统计每日单量MySQL语句

-- 每日单量
select DATE_FORMAT(createtime,"%Y-%m-%d") as days,count(*) count from ibt_shop_order group by days;
-- 每周单量
select DATE_FORMAT(createtime,"%Y-%u") as weeks,count(*) count from ibt_shop_order group by weeks;
-- 每月单量

select DATE_FORMAT(createtime,"%Y-%m") as months,count(*) count from ibt_shop_order group by months;