select count(*) from [la tua tabella] group by date_format(il tuo campo data,'%M')