CREATE TABLE Rooms (decor VARCHAR2, basePrice NUMBER)

Find the average and minimum price of the rooms in different decor.
SELECT decor, AVG(basePrice), MIN(basePrice) FROM Rooms GROUP BY decor
SELECT "decor", AVG("basePrice"), MIN("basePrice") FROM "Rooms" GROUP BY "decor"