mysql 查询 统计每天，每周，每月的数据

根据时间段统计每天的数据

SELECT 
			dayTb.cday '日期', 
			IFNULL(tNumTb.num,0) '人数'
		FROM (
			SELECT @cdate := DATE_ADD(@cdate, INTERVAL +1 DAY) cday
				FROM( SELECT @cdate := DATE_ADD('2021-05-10', INTERVAL -1 DAY) FROM t_customer) t0
				WHERE date(@cdate) <= DATE_ADD('2021-05-30', INTERVAL -1 DAY)
		) dayTb
		LEFT JOIN(
			SELECT date(t.CREATE_DATE) cday,count(t.CUSTOMER_ID) num FROM t_customer t
				WHERE t.CREATE_DATE >='2021-03-10'
				GROUP BY cday
		) tNumTb ON tNumTb.cday = dayTb.cday

根据年份统计每月数据

select
			sum(case month(CREATE_DATE) when '1' then 1 else 0 end) as Jan,
			sum(case month(CREATE_DATE) when '2' then 1 else 0 end) as Feb,
			sum(case month(CREATE_DATE) when '3&#