What are the different product names? What is the average product price for each of them?
CREATE TABLE PRODUCTS (Product_Name VARCHAR, Product_Price INTEGER)
SELECT Product_Name, AVG(Product_Price) FROM PRODUCTS GROUP BY Product_Name
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE PRODUCTS (Product_Name VARCHAR, Product_Price INTEGER) Question: What are the different product names? What is the average product price for each of them? [/INST] SELECT Product_Name, AVG(Product_Price) FROM PRODUCTS GROUP BY Product_Name </s>