CREATE TABLE Apartments (apt_id VARCHAR2, bedroom_count NUMBER)
CREATE TABLE Apartment_Facilities (facility_code VARCHAR2, apt_id VARCHAR2)

Show the facility codes of apartments with 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
SELECT "T1"."facility_code" FROM "Apartment_Facilities" "T1" JOIN "Apartments" "T2" ON "T1"."apt_id" = "T2"."apt_id" AND "T2"."bedroom_count" > 4