What is the average price of all the rooms?
select avg(baseprice) from rooms
What about the minimum price?
select min(baseprice) from rooms
Tell me the average and minimum price of the rooms for each different decor.
select decor, avg(baseprice), min(baseprice) from rooms group by decor;