SELECT investor_id ,  COUNT(*) FROM TRANSACTIONS GROUP BY investor_id
Show the number of transactions for different investors.
SELECT investor_id , COUNT ( * ) FROM TRANSACTIONS GROUP BY investor_id
select investor_id , count ( * ) from transactions group by investor_id
Show the number of transactions for different investors .