Database: cre_Doc_Template_Mgt
Question: Show all document ids and the number of paragraphs in each document. Order by document id.
SQL:
SELECT document_id ,  count(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id