What is the Tourist_ID of the visitor whose detail is 'Vivian'?
select tourist_id from visitors where tourist_details = "Vivian"
Which tourist attractions does she 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 = "Vivian"
How about Vincent?
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"