SELECT bedType ,  count(*) FROM Rooms GROUP BY bedType;
What are the number of rooms for each bed type?
SELECT bedType , count ( * ) FROM Rooms GROUP BY bedType ;
select bedtype , count ( * ) from rooms group by bedtype
What are the number of rooms for each bed type ?