What is the maximum share count of transactions?
select max(share_count) from transactions
What is the average share count of transactions made by each investor?
select investor_id, avg(share_count) from transactions group by investor_id
Please order them by average share count.
select investor_id, avg(share_count) from transactions group by investor_id order by avg(share_count)