Show the transaction id for each financial transaction.
select transaction_id from financial_transactions
Also show the account name for each of them.
select t1.transaction_id, t2.account_name from financial_transactions as t1 join accounts as t2 on t1.account_id = t2.account_id
Limit the results to transactions from accounts with the account name 337.
select t1.transaction_id, t2.account_name from financial_transactions as t1 join accounts as t2 on t1.account_id = t2.account_id where t2.account_name = "337"
How many of those are there?
select count(*) from financial_transactions as t1 join accounts as t2 on t1.account_id = t2.account_id where t2.account_name = "337"