Thanks. What is the visit details of the visitor whose detail is Vincent?
select t2.visit_details from visitors as t1 join visits as t2 on t1.tourist_id = t2.tourist_id where t1.tourist_details = "Vincent"
What about the visit dates?
select t2.visit_date from visitors as t1 join visits as t2 on t1.tourist_id = t2.tourist_id where t1.tourist_details = "Vincent"
Can you show me dates of all visits before the year 2013 only?
select visit_date from visits where visit_date < "2013-01-01 00:00:00"
What are the visit date and details of the visitor whose detail is Toney?
select t2.visit_date, t2.visit_details from visitors as t1 join visits as t2 on t1.tourist_id = t2.tourist_id where t1.tourist_details = "Toney"
What about for Graciela?
select t2.visit_date, t2.visit_details from visitors as t1 join visits as t2 on t1.tourist_id = t2.tourist_id where t1.tourist_details = "Graciela"