codice:
select 
month(data) as mese,
sum(importo) as totale
from tabella
where year(data) = x
group by mese