Can you list all of the apartments with more than 4 bedrooms? | do you mean the apartment ids of apartments with more than 4 bedrooms? | 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
apartments with more than 4 bedrooms refers to bedroom_count > 4; apartment ids refers to apt_id;