Find the average and minimum price of the rooms in different decor.
CREATE TABLE Rooms (decor VARCHAR, basePrice INTEGER)
SELECT decor, AVG(basePrice), MIN(basePrice) FROM Rooms GROUP BY decor
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Rooms (decor VARCHAR, basePrice INTEGER) Question: Find the average and minimum price of the rooms in different decor. [/INST] SELECT decor, AVG(basePrice), MIN(basePrice) FROM Rooms GROUP BY decor </s>