CREATE TABLE Properties (property_name VARCHAR(255), property_type_code VARCHAR(255), room_count VARCHAR(255))
What are the names of properties that are either houses or apartments with more than 1 room?
    
SQL: 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