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