SELECT decor , avg(basePrice) ,  min(basePrice) FROM Rooms GROUP BY decor;
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
Find the average and minimum price of the rooms in different decor .