Database: inn_1
Question: For each bed type, find the average room price.
SQL:
SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;