SELECT investor_id ,  avg(share_count) FROM TRANSACTIONS GROUP BY investor_id
Show the average share count of transactions for different investors.
SELECT investor_id , avg ( share_count ) FROM TRANSACTIONS GROUP BY investor_id
select investor_id , avg ( share_count ) from transactions group by investor_id
Show the average share count of transactions for different investors .