What are all the product types?
select product_type_code from products
Show me all the distinct product types.
select distinct product_type_code from products
How many are there?
select count(distinct product_type_code) from products