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