select autore,count(autore) as tot from tabella group by autore order by tot desc