SELECT YearNumber,
MonthNumber,
SUM(Occurances) AS CountOfData
FROM
(select YEAR(DateField) AS YearNumber,
MONTH(DateField) AS MonthNumber,
Count(datacount) As Occurances
FROM
datatable
GROUP BY SQLDate)Dates
GROUP BY YearNumber,
MonthNumber
Order By YearNumber,
MonthNumber
This should give you what you are looking for.