-- Database schema
| Ref_Feature_Types : feature_type_code [ TEXT ] primary_key , feature_type_name [ TEXT ] | Ref_Property_Types : property_type_code [ TEXT ] primary_key , property_type_description [ TEXT ] | Other_Available_Features : feature_id [ INT ] primary_key , feature_type_code [ TEXT ] Other_Available_Features.feature_type_code = Ref_Feature_Types.feature_type_code , feature_name [ TEXT ] , feature_description [ TEXT ] | Properties : property_id [ INT ] primary_key , property_type_code [ TEXT ] Properties.property_type_code = Ref_Property_Types.property_type_code , date_on_market [ TEXT ] , date_sold [ TEXT ] , property_name [ TEXT ] , property_address [ TEXT ] , room_count [ INT ] , vendor_requested_price [ INT ] , buyer_offered_price [ INT ] , agreed_selling_price [ INT ] , apt_feature_1 [ TEXT ] , apt_feature_2 [ TEXT ] , apt_feature_3 [ TEXT ] , fld_feature_1 [ TEXT ] , fld_feature_2 [ TEXT ] , fld_feature_3 [ TEXT ] , hse_feature_1 [ TEXT ] , hse_feature_2 [ TEXT ] , hse_feature_3 [ TEXT ] , oth_feature_1 [ TEXT ] , oth_feature_2 [ TEXT ] , oth_feature_3 [ TEXT ] , shp_feature_1 [ TEXT ] , shp_feature_2 [ TEXT ] , shp_feature_3 [ TEXT ] , other_property_details [ TEXT ] | Other_Property_Features : property_id [ INT ] Other_Property_Features.property_id = Properties.property_id , feature_id [ INT ] Other_Property_Features.feature_id = Other_Available_Features.feature_id , property_feature_description [ TEXT ] |
-- -- 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;