What is the average base price of different bed type? List bed type and average base price.
CREATE TABLE Rooms (bedType VARCHAR, basePrice INTEGER)
SELECT bedType, AVG(basePrice) FROM Rooms GROUP BY bedType
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT bedType, AVG(basePrice) FROM Rooms GROUP BY bedType </s>