Table schema:
CREATE TABLE users (role_code VARCHAR)

Question: Find the number of users in each role.
SQL: SELECT COUNT(*), role_code FROM users GROUP BY role_code