Task: Text to Code
Input (English): Step 1: For each row in Apartments table, find the corresponding rows in Apartment_Bookings table.
Step 2: find the average bathroom_count in the results of step 1 whose booking_status_code equals Provisional
Output (English): SELECT Avg ( T1.bathroom_count ) FROM Apartments AS T1 JOIN Apartment_Bookings AS T2 ON T1.apt_id = T2.apt_id WHERE T2.booking_status_code = "Provisional"