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
What are the names of properties that are either houses or apartments with more than 1 room?
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
select property_name from properties where property_type_code = value union select property_name from properties where property_type_code = value and room_count > value
What are the names of properties that are either houses or apartments with more than 1 room ?