统计过去N天内每天的某一项数据的总和

有一张表work，每天记录着一个团队不同人的工作量。
数据类似下表

work	date	userid
5	2020-01-05 10:00:36	1
7	2020-01-05 10:22:36	2
8	2020-01-06 10:33:36	1
10	2020-01-06 10:44:36	3

现在统计每天这个团队付出的工作量的总和

	SELECT
		sum(`work`) as `work`,
		substring( `date`, 6, 5 ) AS `date`
		FROM
		`work` 
		WHERE
		AND substring( `date`, 1, 10 ) IN (
		SELECT
		date
		FROM
		(
		SELECT
		@s := @s + 1 AS `index`,
		DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY ) ) AS `date`
		FROM
		mysql.help_topic,
		( SELECT @s := - 1 ) temp
		WHERE
		@s < 6
		ORDER BY
		`date`
		) date
		)
		GROUP BY
		substring(`date`, 6, 5 )
		ORDER BY
		`date`

结果