What are the different role codes for users, and how many users have each?
select count(*), role_code from users group by role_code