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