CREATE TABLE TRANSACTIONS (investor_id VARCHAR2, amount_of_transaction NUMBER)

Show the average amount of transactions for different investors.
SELECT investor_id, AVG(amount_of_transaction) FROM TRANSACTIONS GROUP BY investor_id
SELECT "investor_id", AVG("amount_of_transaction") FROM "TRANSACTIONS" GROUP BY "investor_id"