Thank you! Can you update that list to include the building ID for each of those apartment IDs?
SELECT building_id, apt_id  FROM Apartments WHERE apt_type_code  =  'Flat'
include the building ID for each apartment ID refers to SELECT building_id, apt_id;