SELECT transaction_type_code ,  max(share_count) ,  min(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
select transaction_type_code , max ( share_count ) , min ( share_count ) from transactions group by transaction_type_code
Show the maximum and minimum share count of different transaction types .