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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Financial_transactions (account_id VARCHAR) Question: How many transaction does each account have? Show the number and account id. [/INST] SELECT COUNT(*), account_id FROM Financial_transactions </s>