What are the visit date and details of the visitor whose detail is 'Vincent'?
create table visitors (tourist_id varchar, tourist_details varchar, PRIMARY KEY (tourist_id)); create table visits (visit_date varchar, visit_details varchar, tourist_id varchar, PRIMARY KEY (visit_date))
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 = "vincent"