....
select conut (*)
from tabella
group by IDnazione;