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
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT roomName, RoomId FROM Rooms WHERE basePrice > 160 AND maxOccupancy > 2 </s>