What are the facility codes of all the apartments that have more than 4 bedrooms?
select t1.facility_code from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 4
What are the apartment numbers of those?
select t2.apt_number from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 4
How many bathrooms do each of those have?
select t2.bathroom_count from apartment_facilities as t1 join apartments as t2 on t1.apt_id = t2.apt_id where t2.bedroom_count > 4