Table 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