Database: tracking_share_transactions
Question: Show the average transaction amount for different transaction types.
SQL:
SELECT transaction_type_code ,  avg(amount_of_transaction) FROM TRANSACTIONS GROUP BY transaction_type_code