Show all document ids and the number of paragraphs in each document. Order by document id.
CREATE TABLE Paragraphs (document_id VARCHAR)
SELECT document_id, COUNT(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Paragraphs (document_id VARCHAR) Question: Show all document ids and the number of paragraphs in each document. Order by document id. [/INST] SELECT document_id, COUNT(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id </s>