How many tourist attractions has Vincent visited?
select count(*) 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"
How about Vivian?
select count(*) 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"
Among these attractions, please show the names and dates of the ones that Vincent or Vivian has visited.
select t1.name, t3.visit_date 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" or t2.tourist_details = "Vivian"