For each product type, return the maximum and minimum price.
CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER)
SELECT product_type_code, MAX(product_price), MIN(product_price) FROM products GROUP BY product_type_code
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE products (product_type_code VARCHAR, product_price INTEGER) Question: For each product type, return the maximum and minimum price. [/INST] SELECT product_type_code, MAX(product_price), MIN(product_price) FROM products GROUP BY product_type_code </s>