What apartment type codes and apartment numbers do the buildings managed by "Kyle" have?
SELECT T2.apt_type_code ,  T2.apt_number FROM Apartment_Buildings AS T1 JOIN Apartments AS T2 ON T1.building_id  =  T2.building_id WHERE T1.building_manager  =  "Kyle"
apartment type codes refers to apt_type_code; apartment numbers refers to apt_number; buildings managed by 'Kyle' refers to building_manager = 'Kyle'; JOIN is used to combine rows from two or more tables based on a related column between them;