Find the number of users in each role.
select count(*), role_code from users group by role_code