How many different transaction types are there?
select count(distinct transaction_type_code) from transactions
What is the average share count of different transaction types?
select transaction_type_code, avg(share_count) from transactions group by transaction_type_code
Show the maximum and minimum share count of different transaction types.
select transaction_type_code, max(share_count), min(share_count) from transactions group by transaction_type_code