Tell me the average price of rooms.
select avg(baseprice) from rooms
Report the average room price for each bed type.
select bedtype, avg(baseprice) from rooms group by bedtype;