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"
Find the total number of rooms in the apartments that have facility code "Gym".
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 ''
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 = value
Find the total number of rooms in the apartments that have facility code `` Gym '' .