实现统计本周每天的数量

开始以为分组查询就可以

SELECT DATE_FORMAT(datetime_created, '%m-%d') days,
       count(*)                               count
FROM (SELECT *
      FROM fnd_customer
      WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(datetime_created)) as weekadd

GROUP BY days;

结果出现为空的情况

目前找到解决的办法

SELECT a.statisticDate,
       ifnull(b.count, 0) AS count
FROM (
         SELECT curdate