How many distinct transaction types are used in the transactions?
create table transactions (transaction_type_code varchar, PRIMARY KEY (transaction_type_code))
select count(distinct transaction_type_code) from transactions