今天新学到的按照年月日/周划分查询的sql

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 后面的条件是细分到周，所以后面的统计数据是按周来进行统计的