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
What is the name of the visitor who visited both a museum opened before 2009 and a museum opened after 2011?
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
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 < value 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 > value
What is the name of the visitor who visited both a museum opened before 2009 and a museum opened after 2011 ?