What is the maximum share count of all of the different transaction type codes?
select transaction_type_code, max ( share_count ) from transactions group by transaction_type_code
What is the minimum share count of the transaction type code PUR?
select share_count from transactions where transaction_type_code = 'PUR' and share_count ! = "" order by share_count limit 1
What is the share count of transaction id 2?
select share_count from transactions where transaction_id = 2
What is the lowest share count?
select share_count from transactions where share_count ! = "" order by share_count limit 1