What are the number of rooms for each bed type?
select bedtype, count(*) from rooms group by bedtype;