raggruppare record per data

[nicola75ss]

select count(*) as tot,extract(year_month from campo_data) as mese_anno
from tabella
group by mese_anno
order by mese_anno desc