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;
rooms that have a price higher than 160 refers to basePrice > 160; can accommodate more than 2 people refers to maxOccupancy > 2; report room names and ids refers to SELECT roomName, RoomId;