Group all the rooms by the bed type
select * from rooms group by bedtype;
For each bed type, count the number of rooms.
select bedtype, count(*) from rooms group by bedtype;