SELECT SUM(count1), SUM(count2), SUM(count3), MONTH(month), YEAR(month) FROM myTable GROUP BY MONTH(month), YEAR(month)