Task: Text to Code
Input (English): What are the names of properties that are either houses or apartments with more than 1 room?
Output (English): 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