MySQL中按年+月统计期间数据

sql代码：

SELECT
	DATE_FORMAT(d.create_date, '%Y-%m') AS MONTH,
	sum(d.apply_amount) AS money
FROM
	test d
WHERE
	DATE_FORMAT(d.create_date, '%Y-%m') BETWEEN '2017-02%' AND '2018-02%'
GROUP BY
	MONTH
ORDER BY
	MONTH

结果图：