Database: cre_Doc_Workflow
Question: Show all staff role codes and the number of document processes for each role.
SQL:
SELECT staff_role_code ,  count(*) FROM Staff_in_processes GROUP BY staff_role_code