Show the names and ids of tourist attractions that are visited at least two times Visualize by bar chart, and I want to show in ascending by the X.
CREATE TABLE Hotels (
    hotel_id INTEGER,
    star_rating_code CHAR(15),
    pets_allowed_yn CHAR(1),
    price_range real,
    other_hotel_details VARCHAR(255)
)

CREATE TABLE Tourist_Attraction_Features (
    Tourist_Attraction_ID INTEGER,
    Feature_ID INTEGER
)

CREATE TABLE Royal_Family (
    Royal_Family_ID INTEGER,
    Royal_Family_Details VARCHAR(255)
)

CREATE TABLE Street_Markets (
    Market_ID INTEGER,
    Market_Details VARCHAR(255)
)

CREATE TABLE Visitors (
    Tourist_ID INTEGER,
    Tourist_Details VARCHAR(255)
)

CREATE TABLE Museums (
    Museum_ID INTEGER,
    Museum_Details VARCHAR(255)
)

CREATE TABLE Shops (
    Shop_ID INTEGER,
    Shop_Details VARCHAR(255)
)

CREATE TABLE Features (
    Feature_ID INTEGER,
    Feature_Details VARCHAR(255)
)

CREATE TABLE Ref_Attraction_Types (
    Attraction_Type_Code CHAR(15),
    Attraction_Type_Description VARCHAR(255)
)

CREATE TABLE Photos (
    Photo_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Name VARCHAR(255),
    Description VARCHAR(255),
    Filename VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Locations (
    Location_ID INTEGER,
    Location_Name VARCHAR(255),
    Address VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Visits (
    Visit_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Tourist_ID INTEGER,
    Visit_Date DATETIME,
    Visit_Details VARCHAR(40)
)

CREATE TABLE Staff (
    Staff_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Name VARCHAR(40),
    Other_Details VARCHAR(255)
)

CREATE TABLE Tourist_Attractions (
    Tourist_Attraction_ID INTEGER,
    Attraction_Type_Code CHAR(15),
    Location_ID INTEGER,
    How_to_Get_There VARCHAR(255),
    Name VARCHAR(255),
    Description VARCHAR(255),
    Opening_Hours VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Theme_Parks (
    Theme_Park_ID INTEGER,
    Theme_Park_Details VARCHAR(255)
)

CREATE TABLE Ref_Hotel_Star_Ratings (
    star_rating_code CHAR(15),
    star_rating_description VARCHAR(80)
)
SELECT T1.Name, T1.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN Visits AS T2 ON T1.Tourist_Attraction_ID = T2.Tourist_Attraction_ID ORDER BY T1.Name
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show the names and ids of tourist attractions that are visited at least two times Visualize by bar chart, and I want to show in ascending by the X. ### Input: CREATE TABLE Hotels (
    hotel_id INTEGER,
    star_rating_code CHAR(15),
    pets_allowed_yn CHAR(1),
    price_range real,
    other_hotel_details VARCHAR(255)
)

CREATE TABLE Tourist_Attraction_Features (
    Tourist_Attraction_ID INTEGER,
    Feature_ID INTEGER
)

CREATE TABLE Royal_Family (
    Royal_Family_ID INTEGER,
    Royal_Family_Details VARCHAR(255)
)

CREATE TABLE Street_Markets (
    Market_ID INTEGER,
    Market_Details VARCHAR(255)
)

CREATE TABLE Visitors (
    Tourist_ID INTEGER,
    Tourist_Details VARCHAR(255)
)

CREATE TABLE Museums (
    Museum_ID INTEGER,
    Museum_Details VARCHAR(255)
)

CREATE TABLE Shops (
    Shop_ID INTEGER,
    Shop_Details VARCHAR(255)
)

CREATE TABLE Features (
    Feature_ID INTEGER,
    Feature_Details VARCHAR(255)
)

CREATE TABLE Ref_Attraction_Types (
    Attraction_Type_Code CHAR(15),
    Attraction_Type_Description VARCHAR(255)
)

CREATE TABLE Photos (
    Photo_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Name VARCHAR(255),
    Description VARCHAR(255),
    Filename VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Locations (
    Location_ID INTEGER,
    Location_Name VARCHAR(255),
    Address VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Visits (
    Visit_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Tourist_ID INTEGER,
    Visit_Date DATETIME,
    Visit_Details VARCHAR(40)
)

CREATE TABLE Staff (
    Staff_ID INTEGER,
    Tourist_Attraction_ID INTEGER,
    Name VARCHAR(40),
    Other_Details VARCHAR(255)
)

CREATE TABLE Tourist_Attractions (
    Tourist_Attraction_ID INTEGER,
    Attraction_Type_Code CHAR(15),
    Location_ID INTEGER,
    How_to_Get_There VARCHAR(255),
    Name VARCHAR(255),
    Description VARCHAR(255),
    Opening_Hours VARCHAR(255),
    Other_Details VARCHAR(255)
)

CREATE TABLE Theme_Parks (
    Theme_Park_ID INTEGER,
    Theme_Park_Details VARCHAR(255)
)

CREATE TABLE Ref_Hotel_Star_Ratings (
    star_rating_code CHAR(15),
    star_rating_description VARCHAR(80)
) ### Response: SELECT T1.Name, T1.Tourist_Attraction_ID FROM Tourist_Attractions AS T1 JOIN Visits AS T2 ON T1.Tourist_Attraction_ID = T2.Tourist_Attraction_ID ORDER BY T1.Name