Database: cre_Doc_Control_Systems
Question: Which documents have more than 1 draft copies? List document id and number of draft copies.
SQL:
SELECT document_id , count(*) FROM Draft_Copies GROUP BY document_id HAVING count(*)  >  1;