CREATE TABLE Apartment_Buildings (building_id VARCHAR, building_manager VARCHAR)
CREATE TABLE Apartments (apt_type_code VARCHAR, apt_number VARCHAR, building_id VARCHAR)

Show the apartment type codes and apartment numbers in the buildings managed by 'Kyle'.
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"
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 "Kyle" = "T1"."building_manager"