How many transaction does each account have? Show the number and account id.
CREATE TABLE Financial_transactions (
    account_id VARCHAR
)
SELECT COUNT(*), account_id FROM Financial_transactions
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 transaction does each account have? Show the number and account id. ### Input: CREATE TABLE Financial_transactions (
    account_id VARCHAR
) ### Response: SELECT COUNT(*), account_id FROM Financial_transactions