SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;
For each bed type, find the average room price.
SELECT bedType , avg ( basePrice ) FROM Rooms GROUP BY bedType ;
select bedtype , avg ( baseprice ) from rooms group by bedtype
For each bed type , find the average room price .