Database: inn_1
Question: What is the average base price of different bed type? List bed type and average base price.
SQL:
SELECT bedType ,  avg(basePrice) FROM Rooms GROUP BY bedType;