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
apartment IDs with more than 4 bedrooms refers to bedroom_count > 4; list building id, apartment type code, and apartment number refers to selecting building_id, apt_type_code, apt_number;