Schema: CREATE TABLE Rooms (roomName VARCHAR, RoomId VARCHAR, basePrice VARCHAR, maxOccupancy VARCHAR)
Question: Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids.
SQL: SELECT roomName, RoomId FROM Rooms WHERE basePrice > 160 AND maxOccupancy > 2