CREATE TABLE TRANSACTIONS (transaction_type_code VARCHAR, amount_of_transaction INT)

Show the average transaction amount for different transaction types.
SELECT transaction_type_code, AVG(amount_of_transaction) FROM TRANSACTIONS GROUP BY transaction_type_code
SELECT "transaction_type_code", AVG("amount_of_transaction") FROM "TRANSACTIONS" GROUP BY "transaction_type_code"