Task: Text to Code
Input (English): Step 1: For each row in visit table, find corresponding rows in museum table and in visitor table.
Step 2: find visitor's Name of the results of step 1 whose Open_Year greater than 2009.
Step 3: find visitor's Name of the results of step 1 whose Open_Year less than 2011.
Step 4: show the rows that are in both the results of step 2 and the results of step 3
Output (English): SELECT T2.Name FROM museum AS T1 JOIN visitor AS T2 JOIN visit AS T3 ON T1.Museum_ID = T3.Museum_ID AND T3.visitor_ID = T2.ID WHERE T1.Open_Year > 2009 INTERSECT SELECT T2.Name FROM museum AS T1 JOIN visitor AS T2 JOIN visit AS T3 ON T1.Museum_ID = T3.Museum_ID AND T3.visitor_ID = T2.ID WHERE T1.Open_Year < 2011