Query Run
SET @one_year_ago = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR),... 9 months ago