-- Database schema
| Apartment_Buildings : building_id [ INT ] primary_key , building_short_name [ TEXT ] , building_full_name [ TEXT ] , building_description [ TEXT ] , building_address [ TEXT ] , building_manager [ TEXT ] , building_phone [ TEXT ] | Apartments : apt_id [ INT ] primary_key , building_id [ INT ] Apartments.building_id = Apartment_Buildings.building_id , apt_type_code [ TEXT ] , apt_number [ TEXT ] , bathroom_count [ INT ] , bedroom_count [ INT ] , room_count [ TEXT ] | Apartment_Facilities : apt_id [ INT ] primary_key Apartment_Facilities.apt_id = Apartments.apt_id , facility_code [ TEXT ] | Guests : guest_id [ INT ] primary_key , gender_code [ TEXT ] , guest_first_name [ TEXT ] , guest_last_name [ TEXT ] , date_of_birth [ TEXT ] | Apartment_Bookings : apt_booking_id [ INT ] primary_key , apt_id [ INT ] Apartment_Bookings.apt_id = Apartments.apt_id , guest_id [ INT ] Apartment_Bookings.guest_id = Guests.guest_id , booking_status_code [ TEXT ] , booking_start_date [ TEXT ] , booking_end_date [ TEXT ] | View_Unit_Status : apt_id [ INT ] View_Unit_Status.apt_id = Apartments.apt_id , apt_booking_id [ INT ] View_Unit_Status.apt_booking_id = Apartment_Bookings.apt_booking_id , status_date [ TEXT ] primary_key , available_yn [ TEXT ] |
-- -- Which buildings have apartments that have more than two bathrooms? Give me the addresses of the buildings.

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;