Show the product type codes that have both products with price higher than 4500 and products with price lower than 3000.
CREATE TABLE Products (Product_Type_Code VARCHAR, Product_Price INTEGER)
SELECT Product_Type_Code FROM Products WHERE Product_Price > 4500 INTERSECT SELECT Product_Type_Code FROM Products WHERE Product_Price < 3000
<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: Show the product type codes that have both products with price higher than 4500 and products with price lower than 3000. [/INST] SELECT Product_Type_Code FROM Products WHERE Product_Price > 4500 INTERSECT SELECT Product_Type_Code FROM Products WHERE Product_Price < 3000 </s>