codice:
select zona,count(zona) as quanti
from tabella where zona = 'ROMA'
group by zona
union 
select 'totale',count(*) as quanti from tabella