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