Show different tourist attractions' names, ids, and the corresponding number of visits.
create table visits (tourist_attraction_id varchar, PRIMARY KEY (tourist_attraction_id)); create table tourist_attractions (name varchar, tourist_attraction_id varchar, PRIMARY KEY (name))
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