Database: cre_Doc_Control_Systems
Question: Which document has the most draft copies? List its document id and number of draft copies.
SQL:
SELECT document_id , count(copy_number) FROM Draft_Copies GROUP BY document_id ORDER BY count(copy_number) DESC LIMIT 1;