instruction: Show different tourist attractions' names, ids, and the corresponding number of visits.
response: 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