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
[{'count(*)': 8, 'role_code': 'DBA'}, {'count(*)': 7, 'role_code': 'PROJ-MGR'}]