CREATE TABLE products (product_type_code VARCHAR2, product_price NUMBER)

For each product type, return the maximum and minimum price.
SELECT product_type_code, MAX(product_price), MIN(product_price) FROM products GROUP BY product_type_code
SELECT "product_type_code", MAX("product_price"), MIN("product_price") FROM "products" GROUP BY "product_type_code"