Task: Text to Code
Input (English): Step 1: For each row in Apartment_Bookings table, find corresponding rows in Apartments table and in Guests table.
Step 2: find apt_type_code, apt_number of the results of step 1 whose guest_first_name equals Kyle
Output (English): SELECT T1.apt_type_code , T1.apt_number FROM Apartments AS T1 JOIN Guests AS T2 JOIN Apartment_Bookings AS T3 ON T1.apt_id = T3.apt_id AND T3.guest_id = T2.guest_id WHERE T2.guest_first_name = "Kyle"