List all the rooms in the descending order of the base price.
select * from rooms order by baseprice desc
Which room has the highest base price?
select * from rooms order by baseprice desc limit 1;
Give me the id and name of this room.
select roomid, roomname from rooms order by baseprice desc limit 1;