Hello!  Can you provide me with a list of all the names and ids for all tourist attractions?
select name, tourist_attraction_id from tourist_attractions
Great!  Can you filter this list to show only the names and ids for tourist attractions that were visited 2 or more times?
select t1.name, t2.tourist_attraction_id from tourist_attractions as t1 join visits as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id group by t2.tourist_attraction_id having count ( * ) > = 2
Great!  Can you update this list to show how many times each tourist attraction was visited?
select t1.name, count ( * ) from tourist_attractions as t1 join visits as t2 on t1.tourist_attraction_id = t2.tourist_attraction_id group by t2.tourist_attraction_id having count ( * ) > = 2