Yes please.
select t2.building_id from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.facility_code = "Gym"
How many bathrooms are there in those buildings?
select sum ( t2.bathroom_count ) from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.facility_code = "Gym"
How many bedrooms are there in those buildings?
select sum ( t2.bedroom_count ) from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.facility_code = "Gym"
What is the total number of rooms in those buildings?
select sum ( t2.room_count ) from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t1.facility_code = "Gym"