mysql interval data_在MySQL中使用INTERVAL和CURDATE

I'm building a chart and I want to receive data for each month.

Here's my first request which is working:

SELECT s.GSP_nom AS nom, timestamp, AVG( v.vote + v.prix ) /2 AS avg

FROM votes_serveur AS v

INNER JOIN serveur AS s ON v.idServ = s.idServ

WHERE s.valide =1

AND v.date > CURDATE() -30

GROUP BY s.GSP_nom

ORDER BY avg DESC

But, in my case I've to write 12 request to receive data for the 12 previous months, is there any trick to avoid writing:

// example for the previous month

AND v.date > CURDATE() -60

AND v.date < CURDATE () -30

I heard about INTERVAL, I went to the MySQL doc but i didn't manage to implement it.

Any example of using INTERVAL please?

解决方案AND v.date > (DATE_SUB(CURDATE(), INTERVAL 2 MONTH))

AND v.date < (DATE_SUB(CURDATE(), INTERVAL 1 MONTH))

should work.