query raggruppare per mese

[nicola75ss]

select count(`data`) as quanti,extract(year_month from `data`) as periodo
from notizie
group by periodo
order by periodo