SELECT roomName ,  RoomId FROM Rooms WHERE basePrice  >  160 AND maxOccupancy  >  2;
Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids.
SELECT roomName , RoomId FROM Rooms WHERE basePrice > 160 AND maxOccupancy > 2 ;
select roomname , roomid from rooms where baseprice > value and maxoccupancy > value
Find all the rooms that have a price higher than 160 and can accommodate more than 2 people . Report room names and ids .