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