CREATE TABLE products (product_type_code VARCHAR)

Find the number of different product types.
SELECT COUNT(DISTINCT product_type_code) FROM products
SELECT COUNT(DISTINCT "product_type_code") FROM "products"