Schema: CREATE TABLE Rooms (bedType VARCHAR, basePrice INTEGER)
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