For each bed type, find the average room price.
select bedtype, avg(baseprice) from rooms group by bedtype;