Show the product type code for all products.
select product_type_code from products
For each of them, count the number of products.
select product_type_code, count(*) from products group by product_type_code
Which of them have at least two products?
select product_type_code from products group by product_type_code having count(*) >= 2