CREATE TABLE Accounts (account_id VARCHAR, account_name VARCHAR)
CREATE TABLE Financial_transactions (account_id VARCHAR)

How many transaction does account with name 337 have?
SELECT COUNT(*) FROM Financial_transactions AS T1 JOIN Accounts AS T2 ON T1.account_id = T2.account_id WHERE T2.account_name = "337"
SELECT COUNT(*) FROM "Financial_transactions" AS "T1" JOIN "Accounts" AS "T2" ON "337" = "T2"."account_name" AND "T1"."account_id" = "T2"."account_id"