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