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