Select Sum group by date

[admin]

I have a table containing a name of an event, how much it cost, and when it was.

Is it possible to write a select statement that will tell me how much has been spent on events per month?

This what I tried but mySQL didnt like it.

select SUM(cost) from events group by MONTH(date_created)

Thanks for your help.
Amit