Select Code to Download

select code, username, userid, count(*) as code_count
group by code, username, userid
order by code, code_count

select 
    code, 
...
    rank() over (ORDER BY code_count DESC) as code_rank
where code_rank <= 5
group by code, username, userid