What are the room names and ids of all the rooms that cost more than 160 and can accommodate more than two people.
SELECT roomName ,  RoomId FROM Rooms WHERE basePrice  >  160 AND maxOccupancy  >  2;
rooms that cost more than 160 refers to basePrice > 160; can accommodate more than two people refers to maxOccupancy > 2; room names and ids refers to selecting roomName and RoomId;