CREATE TABLE Financial_transactions (account_id VARCHAR)

How many transaction does each account have? Show the number and account id.
SELECT COUNT(*), account_id FROM Financial_transactions
SELECT COUNT(*), "account_id" FROM "Financial_transactions"