Could you please tell me which room has the cheapest base price?
select * from rooms order by baseprice asc limit 1
Could you please tell me which room has the most expensive base price?
select * from rooms order by baseprice desc limit 1
What is the average base price for all rooms?
select avg ( baseprice ) from rooms
What is the name of the room with the largest max occupancy?
select roomname from rooms order by maxoccupancy desc limit 1