Find the number of rooms with king bed for each decor type.
CREATE TABLE Rooms (decor VARCHAR, bedType VARCHAR)
SELECT decor, COUNT(*) FROM Rooms WHERE bedType = "King" GROUP BY decor
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Rooms (decor VARCHAR, bedType VARCHAR) Question: Find the number of rooms with king bed for each decor type. [/INST] SELECT decor, COUNT(*) FROM Rooms WHERE bedType = "King" GROUP BY decor </s>