CREATE TABLE Apartment_Buildings (building_address VARCHAR, building_id VARCHAR)
CREATE TABLE Apartments (building_id VARCHAR, bathroom_count INT)

Show the addresses of the buildings that have apartments with 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
SELECT "T1"."building_address" FROM "Apartment_Buildings" AS "T1" JOIN "Apartments" AS "T2" ON "T1"."building_id" = "T2"."building_id" AND "T2"."bathroom_count" > 2