MySQL之统计近七天的数量

-- 返回的是某月某日的数量
SELECT
	monthDay, count( 0 ) AS numb 
FROM
	(
		SELECT 
		-- 返回的是月日
		date_format( create_date, '%m-%d' ) monthDay 
	FROM
		tb_product 
	WHERE
		create_date BETWEEN STR_TO_DATE( date_format( date_sub( now(), INTERVAL 7 DAY ), '%Y-%m-%d 00:00:00' ), '%Y-%m-%d %H:%i:%s' ) 
		AND STR_TO_DATE( date_format( date_sub( now(), INTERVAL 1 DAY ), '%Y-%m-%d 23:59:59' ), '%Y-%m-%d %H:%i:%s' ) 
	) temp 
GROUP BY temp.monthDay