instruction: Bin all date of transactions into the YEAR interval, and give the average of the share count for each bin What is the trend?, sort x-axis in desc order.
response: SELECT date_of_transaction, AVG(share_count) FROM Transactions ORDER BY date_of_transaction DESC