SELECT C.Citta, SUM(A.Incidenti) as N_Incidenti, SUM(A.Morti) as N_Morti, SUM(A.Rapine) as N_Rapine
FROM Citta C
INNER JOIN Avvenimenti A
ON A.IDCitta = C.IDCitta
GROUP BY C.Citta