Yes, what are their names?
select distinct ( name ) from tourist_attractions
Which attractions did Vincent go to?
select * from tourist_attractions as t1 join visitors as t2 join visits as t3 on t1.tourist_attraction_id = t3.tourist_attraction_id and t2.tourist_id = t3.tourist_id where t2.tourist_details = "Vincent"
Which attractions did Vivian visit?
select * from tourist_attractions as t1 join visitors as t2 join visits as t3 on t1.tourist_attraction_id = t3.tourist_attraction_id and t2.tourist_id = t3.tourist_id where t2.tourist_details = "Vivian"
What are the names of the other tourist?
select tourist_details from visitors where tourist_details ! = "Vivian" and tourist_details! = "Vincent"