CREATE TABLE VISITORS (Tourist_ID VARCHAR2, Tourist_Details VARCHAR2)
CREATE TABLE Tourist_Attractions (Name VARCHAR2, Tourist_Attraction_ID VARCHAR2)
CREATE TABLE VISITS (Tourist_Attraction_ID VARCHAR2, Tourist_ID VARCHAR2)

Which tourist attractions does the visitor with detail 'Vincent' visit?
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"
SELECT "T1"."Name" FROM "Tourist_Attractions" "T1" JOIN "VISITS" "T2" ON "T1"."Tourist_Attraction_ID" = "T2"."Tourist_Attraction_ID" JOIN "VISITORS" "T3" ON "T2"."Tourist_ID" = "T3"."Tourist_ID" AND "T3"."Tourist_Details" = "Vincent"