Yes, please!  I believe that's the only discrete identifier of the apartments (at least that I can see)...
select apt_id from apartments where bedroom_count > 4
Thank you!  Can you list the facility codes for each of those apartment IDs (3 4 6 11 12 13 15)?
select t2.facility_code from apartments as t1 join apartment_facilities as t2 on t1.apt_id = t2.apt_id where t1.bedroom_count > 4
Can you please list the 'building id', 'apartment type code' and 'apartment number' for all apartment IDs with more than 4 bedrooms?
select building_id,apt_type_code,apt_number from apartments where bedroom_count > 4