Task: Text to Code
Input (English): Step 1: For each row in Residents table, find the corresponding rows in Customer_Events table.
Step 2: find Customer_Event_ID, Customer_Events's date_moved_in, Residents's date_moved_in of the results of step 1
Output (English): SELECT T2.Customer_Event_ID , T2.date_moved_in , T1.date_moved_in FROM Residents AS T1 JOIN Customer_Events AS T2 ON T1.date_moved_in = T2.date_moved_in