Find the number of users in each role.
CREATE TABLE users (role_code VARCHAR)
SELECT COUNT(*), role_code FROM users GROUP BY role_code
### Context: CREATE TABLE users (role_code VARCHAR) ### Question: Find the number of users in each role. ### Answer: SELECT COUNT(*), role_code FROM users GROUP BY role_code