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