Database: tracking_share_transactions
Question: Show the average amount of transactions for different lots, ordered by average amount of transactions.
SQL:
SELECT T2.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)