Which document has the most draft copies? List its document id and number of draft copies.
CREATE TABLE Draft_Copies (document_id VARCHAR, copy_number VARCHAR)
SELECT TOP 1 document_id, COUNT(copy_number) FROM Draft_Copies GROUP BY document_id ORDER BY COUNT(copy_number) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Draft_Copies (document_id VARCHAR, copy_number VARCHAR) Question: Which document has the most draft copies? List its document id and number of draft copies. [/INST] SELECT TOP 1 document_id, COUNT(copy_number) FROM Draft_Copies GROUP BY document_id ORDER BY COUNT(copy_number) DESC </s>