What are the names of properties that are either houses or apartments with more than 1 room?
CREATE TABLE Properties (property_name VARCHAR, property_type_code VARCHAR, room_count VARCHAR)
SELECT property_name FROM Properties WHERE property_type_code = "House" UNION SELECT property_name FROM Properties WHERE property_type_code = "Apartment" AND room_count > 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Properties (property_name VARCHAR, property_type_code VARCHAR, room_count VARCHAR) Question: What are the names of properties that are either houses or apartments with more than 1 room? [/INST] SELECT property_name FROM Properties WHERE property_type_code = "House" UNION SELECT property_name FROM Properties WHERE property_type_code = "Apartment" AND room_count > 1 </s>