Find the number of rooms for each bed type.
CREATE TABLE Rooms (bedType VARCHAR)
SELECT bedType, COUNT(*) FROM Rooms GROUP BY bedType
### Context: CREATE TABLE Rooms (bedType VARCHAR) ### Question: Find the number of rooms for each bed type. ### Answer: SELECT bedType, COUNT(*) FROM Rooms GROUP BY bedType