Can you show me all the tourist attractions' names?
select distinct name from tourist_attractions
yes
select name, tourist_attraction_id from tourist_attractions
In addition, can you also show me the corresponding number of visits in the same list?
select t1.name, t2.tourist_attraction_id, 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