Database: cre_Doc_Workflow
Question: Show all process ids and the number of documents in each process.
SQL:
SELECT process_id ,  count(*) FROM Documents_processes GROUP BY process_id