Find the number of rooms for each bed type.
select bedtype, count(*) from rooms group by bedtype;