mysql按照指定的天数对日期字段进行分组
解决思想其实就是算出一个日期区间内天数除分组的天数得到的商进行分组
-- 28天月用电量均值
SELECT
com_code, avgPower, month
FROM
(SELECT
cons.com_code,
AVG(acture_day_amount) avgPower,
(DATEDIFF('2020-08-31', measure_date) DIV 28) AS `month`
FROM
power_marketing_test.tb_retail_gen_sale_market_consumer_consumption cons
WHERE
measure_date >= '2019-06-01'
AND measure_date <= '2020-08-31'
GROUP BY com_code , `month`) childAvg
WHERE
month < 3;