CREATE TABLE visitor (name VARCHAR(255), id VARCHAR(255)); CREATE TABLE museum (Museum_ID VARCHAR(255), open_year INTEGER); CREATE TABLE visit (visitor_id VARCHAR(255), Museum_ID VARCHAR(255))
What is the name of the visitor who visited both a museum opened before 2009 and a museum opened after 2011?
    
SQL: SELECT t1.name FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id JOIN museum AS t3 ON t3.Museum_ID = t2.Museum_ID WHERE t3.open_year < 2009 INTERSECT SELECT t1.name FROM visitor AS t1 JOIN visit AS t2 ON t1.id = t2.visitor_id JOIN museum AS t3 ON t3.Museum_ID = t2.Museum_ID WHERE t3.open_year > 2011