Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
### Context:
CREATE TABLE Paragraphs (document_id VARCHAR)
### Question:
Show all document ids and the number of paragraphs in each document. Order by document id.
### Answer:
SELECT document_id, COUNT(*) FROM Paragraphs GROUP BY document_id ORDER BY document_id