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
maximum share count = MAX(share_count); of all the different transaction type codes refers to GROUP BY transaction_type_code;