SELECT Cognome, SUM(Valuta) FROM Tabella GROUP BY Cognome

that easy!!!