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
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 )
What are the dates of those transactions?
select date_of_transaction from transactions
What about just the ones with the transaction type code SALE?
select date_of_transaction from transactions where transaction_type_code = "SALE"
What about transactions with type code PUR?
select date_of_transaction from transactions where transaction_type_code = "PUR"