Task: Text to Code
Input (English): Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids.
Output (English): SELECT roomName ,  RoomId FROM Rooms WHERE basePrice  >  160 AND maxOccupancy  >  2