Show ids for all transactions whose amounts are greater than the average.
create table financial_transactions (transaction_id varchar, transaction_amount integer, PRIMARY KEY (transaction_id))
select transaction_id from financial_transactions where transaction_amount > (select avg(transaction_amount) from financial_transactions)