What is the average base price of different bed type? List bed type and average base price.
CREATE TABLE Rooms (bedType VARCHAR, basePrice INTEGER)
[SQL] SELECT bedType, AVG(basePrice) FROM Rooms GROUP BY bedType [/SQL]