How many documents correspond with each project id?
CREATE TABLE documents (
    document_id number,
    document_type_code text,
    project_id number,
    document_date time,
    document_name text,
    document_description text,
    other_details text
)

CREATE TABLE documents_with_expenses (
    document_id number,
    budget_type_code text,
    document_details text
)

CREATE TABLE statements (
    statement_id number,
    statement_details text
)

CREATE TABLE accounts (
    account_id number,
    statement_id number,
    account_details text
)

CREATE TABLE ref_budget_codes (
    budget_type_code text,
    budget_type_description text
)

CREATE TABLE projects (
    project_id number,
    project_details text
)

CREATE TABLE ref_document_types (
    document_type_code text,
    document_type_name text,
    document_type_description text
)
SELECT project_id, COUNT(*) FROM documents GROUP BY project_id
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many documents correspond with each project id? ### Input: CREATE TABLE documents (
    document_id number,
    document_type_code text,
    project_id number,
    document_date time,
    document_name text,
    document_description text,
    other_details text
)

CREATE TABLE documents_with_expenses (
    document_id number,
    budget_type_code text,
    document_details text
)

CREATE TABLE statements (
    statement_id number,
    statement_details text
)

CREATE TABLE accounts (
    account_id number,
    statement_id number,
    account_details text
)

CREATE TABLE ref_budget_codes (
    budget_type_code text,
    budget_type_description text
)

CREATE TABLE projects (
    project_id number,
    project_details text
)

CREATE TABLE ref_document_types (
    document_type_code text,
    document_type_name text,
    document_type_description text
) ### Response: SELECT project_id, COUNT(*) FROM documents GROUP BY project_id