1.
SELECT DATE_FORMAT(date,'%Y-%m') as mydate,sum(money) mymoney from income
WHERE DATE_FORMAT(date, '%Y-%m') > DATE_FORMAT(date_sub(curdate(), INTERVAL 12 MONTH),
'%Y-%m') GROUP BY mydate
1.
SELECT DATE_FORMAT(date,'%Y-%m') as mydate,sum(money) mymoney from income
WHERE DATE_FORMAT(date, '%Y-%m') > DATE_FORMAT(date_sub(curdate(), INTERVAL 12 MONTH),
'%Y-%m') GROUP BY mydate