Database: cre_Doc_and_collections
Question: What is the number of child documents for each parent document, and what are the ids of the parent documents?
SQL:
SELECT T2.Document_Object_ID ,  count(*) FROM Document_Objects AS T1 JOIN Document_Objects AS T2 ON T1.Parent_Document_Object_ID = T2.Document_Object_ID GROUP BY T2.Document_Object_ID;