What are all the users?
select * from users
What are the different kinds of roles among them?
select role_code from users group by role_code
Show the number of users in each role.
select count(*), role_code from users group by role_code