Which documents have more than 1 draft copies? List document id and number of draft copies.
CREATE TABLE Draft_Copies (document_id VARCHAR)
SELECT document_id, COUNT(*) FROM Draft_Copies GROUP BY document_id HAVING COUNT(*) > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Draft_Copies (document_id VARCHAR) Question: Which documents have more than 1 draft copies? List document id and number of draft copies. [/INST] SELECT document_id, COUNT(*) FROM Draft_Copies GROUP BY document_id HAVING COUNT(*) > 1 </s>