mysql统计本月每周、每天的订单量

统计本月每周的订单量 周数并显示为1、2、3、4

SELECT (WEEK(confirm_time)+1)-WEEK(date_add(DATE_ADD(curdate(),interval -day(curdate())+1 day),interval 6 day),2) as week,
               SUM(IF(order_status = '7', 1, 0)) unableFinishOrder,
               SUM(IF(order_status = '3', 1, 0)) finishOrder
        FROM order_base WHERE YEAR(confirm_time) = YEAR(NOW()) 
        and confirm_time BETWEEN startDate AND endDate
        and state=1 GROUP BY week ORDER BY week

统计每天的订单量

select date_format(confirm_time,'%Y%m%d') as days,
               SUM(IF(order_status = '7', 1, 0)) unableFinishOrder,
               SUM(IF(order_status = '3', 1, 0)) finishOrder
        from order_base where state=1
            and confirm_time BETWEEN #{startDate} AND #{endDate}
        group by days order by days