SELECT
YEAR ( findate ) AS 年,
MONTH ( findate ) AS 月,
WEEK(findate) AS `周`,
DAY(findate) AS `日`,
DATE_FORMAT(findate,'%Y-%m-%d') `日期`,
SUM( bno ) / COUNT( findate ) `比例`
FROM
sp_breed_farrow
WHERE
findate IN ( SELECT findate FROM sp_breed_farrow WHERE findate IS NOT NULL )
AND findate BETWEEN '2010-08-19'
AND '2020-02-16'
GROUP BY
YEAR(findate),
MONTH ( findate ),
WEEK(findate)
ORDER BY
YEAR ( findate ) DESC,
MONTH ( findate ) ASC
这里Group By 后面的条件是细分到周,所以后面的统计数据是按周来进行统计的