Show ids for all transactions.
select transaction_id from financial_transactions
What is the average transaction amount?
select avg(transaction_amount) from financial_transactions
What are the ids of transactions whose amount is greater than it?
select transaction_id from financial_transactions where transaction_amount > (select avg(transaction_amount) from financial_transactions)