CREATE TABLE Tourist_Attractions (Name VARCHAR, Tourist_Attraction_ID VARCHAR)
CREATE TABLE VISITS (Tourist_Attraction_ID VARCHAR)

Show the names and ids of tourist attractions that are visited at least two 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
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