Could you please show me the average share count of transactions of each investor?
SELECT investor_id ,  avg ( share_count )  FROM TRANSACTIONS GROUP BY investor_id
average share count of transactions of each investor = AVG(share_count); grouping by each investor requires GROUP BY investor_id;