Could you order those by average share count, please?
SELECT investor_id ,  avg ( share_count )  FROM TRANSACTIONS GROUP BY investor_id ORDER BY avg ( share_count ) 
order by average share count refers to ORDER BY AVG(share_count);