CREATE TABLE Transactions (transaction_id NUMBER, investor_id NUMBER, transaction_type_code VARCHAR2, date_of_transaction DATETIME, amount_of_transaction NUMBER, share_count VARCHAR2, other_details VARCHAR2)
CREATE TABLE Ref_Transaction_Types (transaction_type_code VARCHAR2, transaction_type_description VARCHAR2)
CREATE TABLE Purchases (purchase_transaction_id NUMBER, purchase_details VARCHAR2)
CREATE TABLE Lots (lot_id NUMBER, investor_id NUMBER, lot_details VARCHAR2)
CREATE TABLE Sales (sales_transaction_id NUMBER, sales_details VARCHAR2)
CREATE TABLE Transactions_Lots (transaction_id NUMBER, lot_id NUMBER)
CREATE TABLE Investors (investor_id NUMBER, Investor_details VARCHAR2)

Show the average amount of transactions for different lots, ordered by average amount of transactions by a scatter chart.
SELECT lot_id, AVG(amount_of_transaction) FROM Transactions AS T1 JOIN Transactions_Lots AS T2 ON T1.transaction_id = T2.transaction_id GROUP BY T2.lot_id ORDER BY AVG(amount_of_transaction)
SELECT "lot_id", AVG("amount_of_transaction") FROM "Transactions" "T1" JOIN "Transactions_Lots" "T2" ON "T1"."transaction_id" = "T2"."transaction_id" GROUP BY "T2"."lot_id" ORDER BY AVG("amount_of_transaction")