Show me the addresses of the buildings.
select building_address from apartment_buildings
Yes
select t1.building_address from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t2.bedroom_count > 1
How about more than 2 bathrooms?
select t1.building_address from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id where t2.bathroom_count > 2