Which tourist attractions does the visitor with detail 'Vincent' visit?
create table visits (tourist_attraction_id varchar, tourist_id varchar, PRIMARY KEY (tourist_attraction_id)); create table visitors (tourist_id varchar, tourist_details varchar, PRIMARY KEY (tourist_id)); create table tourist_attractions (name varchar, tourist_attraction_id varchar, PRIMARY KEY (name))
select t1.name from tourist_attractions as t1 join visits as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id join visitors as t3 on t2.tourist_id = t3.tourist_id where t3.tourist_details = "vincent"