Count Entity Versions

select username, count(*) as version_count
from ores.accounts
group by username
having count(*) > 1
order by version_count desc;