CREATE TABLE Rooms (roomName VARCHAR2, RoomId VARCHAR2, basePrice VARCHAR2, maxOccupancy VARCHAR2)

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" > 160 AND "maxOccupancy" > 2