CREATE TABLE products (product_type_code VARCHAR2)

Show the product type codes which have at least two products.
SELECT product_type_code FROM products GROUP BY product_type_code HAVING COUNT(*) >= 2
SELECT "product_type_code" FROM "products" GROUP BY "product_type_code" HAVING COUNT(*) >= 2