Show the number of transactions with transaction type code "SALE" for different investors if it is larger than 0.
create table transactions (investor_id varchar, transaction_type_code varchar, PRIMARY KEY (investor_id))
select investor_id, count(*) from transactions where transaction_type_code = "sale" group by investor_id