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