What is the average amount of transaction?
select avg ( transaction_amount ) from financial_transactions
What are ids of all transactions with amount greater than the average?
select transaction_id from financial_transactions where transaction_amount > ( select avg ( transaction_amount ) from financial_transactions )
And what are their transaction dates?
select transaction_date from financial_transactions where transaction_amount > ( select avg ( transaction_amount ) from financial_transactions )