SELECT Citta, COUNT(*) FROM tabellaspedizioni GROUP BY Citta

that easy!!!!