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 <table_name> : Tourist_Attractions col : Tourist_Attraction_ID | Attraction_Type_Code | Location_ID | How_to_Get_There | Name | Description | Opening_Hours | Other_Details row 1 : 2113 | 2 | 579 | bus | art museum |  |  |  row 2 : 2701 | 6 | 417 | walk | UK gallery |  |  |  row 3 : 5076 | 2 | 868 | shuttle | flying elephant |  |  |  row 4 : 5265 | 5 | 603 | bus | film festival |  |  |  row 5 : 6476 | 3 | 417 | shuttle | US museum |  |  |  row 6 : 6523 | 9 | 858 | walk | fun games |  |  |  row 7 : 6653 | 9 | 655 | walk | history gallery |  |  |  row 8 : 6852 | 5 | 858 | walk | exploration trial |  |  |  row 9 : 7067 | 5 | 417 | bus | haunted mansion |  |  |  row 10 : 8429 | 9 | 867 | walk | presidents hall |  |  |  row 11 : 8449 | 2 | 579 | bus | impressions de France |  |  |  row 12 : 8698 | 5 | 661 | bus | jungle cruise |  |  |  row 13 : 9360 | 5 | 868 | shuttle | fun shops |  |  |  row 14 : 9561 | 2 | 759 | bus | cafe |  |  |  row 15 : 9919 | 6 | 579 | shuttle | parking |  |  | <table_name> : Visits col : Visit_ID | Tourist_Attraction_ID | Tourist_ID | Visit_Date | Visit_Details row 1 : 183 | 6653 | 377 | 2004-08-21 03:06:14 |  row 2 : 268 | 5076 | 204 | 2013-08-06 05:35:51 |  row 3 : 273 | 9360 | 211 | 2013-10-27 09:56:08 |  row 4 : 302 | 6476 | 377 | 1990-08-15 14:24:10 |  row 5 : 356 | 6476 | 439 | 1980-11-26 02:08:00 |  row 6 : 381 | 6523 | 211 | 2017-03-19 08:48:19 |  row 7 : 416 | 6476 | 841 | 2008-11-09 01:28:01 |  row 8 : 479 | 6852 | 439 | 1989-08-24 20:26:37 |  row 9 : 563 | 6852 | 610 | 1993-02-01 15:27:20 |  row 10 : 612 | 9919 | 204 | 2007-09-17 10:12:45 |  row 11 : 729 | 6476 | 513 | 1998-05-12 00:50:20 |  row 12 : 776 | 8698 | 513 | 2010-10-04 01:34:12 |  row 13 : 781 | 6852 | 779 | 2018-01-09 20:39:52 |  row 14 : 866 | 8429 | 545 | 1971-12-16 06:41:26 |  row 15 : 909 | 8698 | 779 | 1998-12-10 02:46:43 |  row 16 : 937 | 6523 | 541 | 1996-01-08 13:23:41 |  row 17 : 962 | 9919 | 610 | 2007-09-03 04:30:01 |  row 18 : 968 | 6852 | 377 | 1974-12-31 23:18:24 |  row 19 : 977 | 8698 | 500 | 2001-11-13 10:08:28 |  row 20 : 999 | 2701 | 610 | 1990-11-12 00:54:50 |
col : Name | Tourist_Attraction_ID row 1 : US museum | 6476 row 2 : fun games | 6523 row 3 : exploration trial | 6852 row 4 : jungle cruise | 8698 row 5 : parking | 9919