Find all the rooms whose price is above 160.
select * from rooms where baseprice > 160
Of those, which rooms can accommodate more than two people?
select * from rooms where baseprice > 160 and maxoccupancy > 2;
Give me the name and id of those rooms.
select roomname, roomid from rooms where baseprice > 160 and maxoccupancy > 2;