select nome,count(nome) as quanti from tabella group by nome order by quanti desc