text: 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