CREATE TABLE apartments (apt_id DECIMAL, building_id DECIMAL, apt_type_code TEXT, apt_number TEXT, bathroom_count DECIMAL, bedroom_count DECIMAL, room_count TEXT)
CREATE TABLE apartment_facilities (apt_id DECIMAL, facility_code TEXT)
CREATE TABLE apartment_buildings (building_id DECIMAL, building_short_name TEXT, building_full_name TEXT, building_description TEXT, building_address TEXT, building_manager TEXT, building_phone TEXT)
CREATE TABLE apartment_bookings (apt_booking_id DECIMAL, apt_id DECIMAL, guest_id DECIMAL, booking_status_code TEXT, booking_start_date TIME, booking_end_date TIME)
CREATE TABLE view_unit_status (apt_id DECIMAL, apt_booking_id DECIMAL, status_date TIME, available_yn others)
CREATE TABLE guests (guest_id DECIMAL, gender_code TEXT, guest_first_name TEXT, guest_last_name TEXT, date_of_birth TIME)

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"