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