Quais são os nomes de propriedades que são casas ou apartamentos com mais de 1 quarto?
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