Group all the rooms by the bed type.
select * from rooms group by bedtype;
For each bed type, find the average base price of different bed type.
select bedtype, avg(baseprice) from rooms group by bedtype;