Translate the following question to SQL: How many accounts does each customer have? List the number and customer id.

Schema: CREATE TABLE Customers (
    customer_id INTEGER   PRIMARY KEY,
    customer_first_name VARCHAR(50),
    customer_middle_initial VARCHAR(1),
    customer_last_name VARCHAR(50),
    gender VARCHAR(1),
    email_address VARCHAR(255),
    login_name VARCHAR(80),
    login_password VARCHAR(20),
    phone_number VARCHAR(255),
    town_city VARCHAR(50),
    state_county_province VARCHAR(50),
    country VARCHAR(50)
);

CREATE TABLE Orders (
    order_id INTEGER   PRIMARY KEY,
    customer_id INTEGER NOT NULL,
    date_order_placed DATETIME NOT NULL,
    order_details VARCHAR(255),
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);

CREATE TABLE Invoices (
    invoice_number INTEGER   PRIMARY KEY,
    order_id INTEGER NOT NULL,
    invoice_date DATETIME,
    FOREIGN KEY (order_id) REFERENCES Orders(order_id)
);

CREATE TABLE Accounts (
    account_id INTEGER   PRIMARY KEY,
    customer_id INTEGER NOT NULL,
    date_account_opened DATETIME,
    account_name VARCHAR(50),
    other_account_details VARCHAR(255),
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);

CREATE TABLE Product_Categories (
    production_type_code VARCHAR(15)   PRIMARY KEY,
    product_type_description VARCHAR(80),
    vat_rating DECIMAL(19,4),
    UNIQUE (production_type_code)
);

CREATE TABLE Products (
    product_id INTEGER   PRIMARY KEY,
    parent_product_id INTEGER,
    production_type_code VARCHAR(15) NOT NULL,
    unit_price DECIMAL(19,4),
    product_name VARCHAR(80),
    product_color VARCHAR(20),
    product_size VARCHAR(20),
    FOREIGN KEY (production_type_code) REFERENCES Product_Categories(production_type_code)
);

CREATE TABLE Financial_Transactions (
    transaction_id INTEGER NOT NULL,
    account_id INTEGER NOT NULL,
    invoice_number INTEGER,
    transaction_type VARCHAR(15) NOT NULL,
    transaction_date DATETIME,
    transaction_amount DECIMAL(19,4),
    transaction_comment VARCHAR(255),
    other_transaction_details VARCHAR(255),
    FOREIGN KEY (account_id) REFERENCES Accounts(account_id),
    FOREIGN KEY (invoice_number) REFERENCES Invoices(invoice_number)
);

CREATE TABLE Order_Items (
    order_item_id INTEGER   PRIMARY KEY,
    order_id INTEGER NOT NULL,
    product_id INTEGER NOT NULL,
    product_quantity VARCHAR(50),
    other_order_item_details VARCHAR(255),
    FOREIGN KEY (order_id) REFERENCES Orders(order_id),
    FOREIGN KEY (product_id) REFERENCES Products(product_id)
);

CREATE TABLE Invoice_Line_Items (
    order_item_id INTEGER NOT NULL,
    invoice_number INTEGER NOT NULL,
    product_id INTEGER NOT NULL,
    product_title VARCHAR(80),
    product_quantity VARCHAR(50),
    product_price DECIMAL(19,4),
    derived_product_cost DECIMAL(19,4),
    derived_vat_payable DECIMAL(19,4),
    derived_total_cost DECIMAL(19,4),
    FOREIGN KEY (product_id) REFERENCES Products(product_id),
    FOREIGN KEY (invoice_number) REFERENCES Invoices(invoice_number),
    FOREIGN KEY (order_item_id) REFERENCES Order_Items(order_item_id)
);
user
SELECT count(*) ,  customer_id FROM Accounts GROUP BY customer_id
assistant