How many rooms are there?
select count ( * ) from rooms
What are their prices?
select baseprice from rooms
What is the id of the room with a base price of 250?
select roomid from rooms where baseprice = 250
What is the name of that room?
select roomname from rooms where baseprice = 250