can you show me a list of transaction type code?
select transaction_type_code from transactions
what is the average of amount of transaction?
select avg ( amount_of_transaction ) from transactions
can you show me a list of share count?
select share_count from transactions
show the transaction type code that occurs the fewest times.
select transaction_type_code from transactions group by transaction_type_code order by count ( * ) asc limit 1