Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids.
CREATE TABLE Rooms (
    roomName VARCHAR,
    RoomId VARCHAR,
    basePrice VARCHAR,
    maxOccupancy VARCHAR
)
SELECT roomName, RoomId FROM Rooms WHERE basePrice > 160 AND maxOccupancy > 2
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find all the rooms that have a price higher than 160 and can accommodate more than 2 people. Report room names and ids. ### Input: CREATE TABLE Rooms (
    roomName VARCHAR,
    RoomId VARCHAR,
    basePrice VARCHAR,
    maxOccupancy VARCHAR
) ### Response: SELECT roomName, RoomId FROM Rooms WHERE basePrice > 160 AND maxOccupancy > 2