select count(*) as num, cod_ut from soci group by cod_ut

poi leggi num e cod_ut