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)
Show the average amount of transactions for different lots, ordered by average amount of transactions.
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 )
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 )
Show the average amount of transactions for different lots , ordered by average amount of transactions .