List all the addresses of the buildings.
select building_address from apartment_buildings
Show the building address for each apartment id.
select t1.building_address, t2.apt_id from apartment_buildings as t1 join apartments as t2 on t1.building_id = t2.building_id
Only show the addresses of the buildings that have apartments with more than 3 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 > 3
How about more than 2?
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