Database: inn_1
Question: What are the number of rooms for each bed type?
SQL:
SELECT bedType ,  count(*) FROM Rooms GROUP BY bedType;