Find the number of rooms with price higher than 120 for different decor.
CREATE TABLE Rooms (decor VARCHAR, basePrice INTEGER)
SELECT decor, COUNT(*) FROM Rooms WHERE basePrice > 120 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 number of rooms with price higher than 120 for different decor. [/INST] SELECT decor, COUNT(*) FROM Rooms WHERE basePrice > 120 GROUP BY decor </s>