Database: inn_1
Question: What is the average minimum and price of the rooms for each different decor.
SQL:
SELECT decor , avg(basePrice) ,  min(basePrice) FROM Rooms GROUP BY decor;