select codice_fiscale,sum(superfieie) as tot from tabella group by codice_fiscale