CREATE TABLE Ref_Hotel_Star_Ratings (
    star_rating_code TEXT PRIMARY KEY,
    star_rating_description TEXT
);
CREATE TABLE Locations (
    Location_ID NUMBER PRIMARY KEY,
    Location_Name TEXT,
    Address TEXT,
    Other_Details TEXT
);
CREATE TABLE Ref_Attraction_Types (
    Attraction_Type_Code TEXT PRIMARY KEY,
    Attraction_Type_Description TEXT
);
CREATE TABLE Visitors (
    Tourist_ID NUMBER PRIMARY KEY,
    Tourist_Details TEXT
);
CREATE TABLE Features (
    Feature_ID NUMBER PRIMARY KEY,
    Feature_Details TEXT
);
CREATE TABLE Hotels (
    hotel_id NUMBER PRIMARY KEY,
    star_rating_code TEXT,
    pets_allowed_yn TEXT,
    price_range NUMBER,
    other_hotel_details TEXT,
    FOREIGN KEY ("star_rating_code") REFERENCES Ref_Hotel_Star_Ratings("star_rating_code")
);
CREATE TABLE Tourist_Attractions (
    Tourist_Attraction_ID NUMBER PRIMARY KEY,
    Attraction_Type_Code TEXT,
    Location_ID NUMBER,
    How_to_Get_There TEXT,
    Name TEXT,
    Description TEXT,
    Opening_Hours TEXT,
    Other_Details TEXT,
    FOREIGN KEY ("Attraction_Type_Code") REFERENCES Ref_Attraction_Types("Attraction_Type_Code"),
    FOREIGN KEY ("Location_ID") REFERENCES Locations("Location_ID")
);
CREATE TABLE Street_Markets (
    Market_ID NUMBER PRIMARY KEY,
    Market_Details TEXT,
    FOREIGN KEY ("Market_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Shops (
    Shop_ID NUMBER PRIMARY KEY,
    Shop_Details TEXT,
    FOREIGN KEY ("Shop_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Museums (
    Museum_ID NUMBER PRIMARY KEY,
    Museum_Details TEXT,
    FOREIGN KEY ("Museum_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Royal_Family (
    Royal_Family_ID NUMBER PRIMARY KEY,
    Royal_Family_Details TEXT,
    FOREIGN KEY ("Royal_Family_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Theme_Parks (
    Theme_Park_ID NUMBER PRIMARY KEY,
    Theme_Park_Details TEXT,
    FOREIGN KEY ("Theme_Park_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Visits (
    Visit_ID NUMBER PRIMARY KEY,
    Tourist_Attraction_ID NUMBER,
    Tourist_ID NUMBER,
    Visit_Date TIME,
    Visit_Details TEXT,
    FOREIGN KEY ("Tourist_ID") REFERENCES Visitors("Tourist_ID"),
    FOREIGN KEY ("Tourist_Attraction_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Photos (
    Photo_ID NUMBER PRIMARY KEY,
    Tourist_Attraction_ID NUMBER,
    Name TEXT,
    Description TEXT,
    Filename TEXT,
    Other_Details TEXT,
    FOREIGN KEY ("Tourist_Attraction_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Staff (
    Staff_ID NUMBER PRIMARY KEY,
    Tourist_Attraction_ID NUMBER,
    Name TEXT,
    Other_Details TEXT,
    FOREIGN KEY ("Tourist_Attraction_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);
CREATE TABLE Tourist_Attraction_Features (
    Tourist_Attraction_ID NUMBER PRIMARY KEY,
    Feature_ID NUMBER,
    FOREIGN KEY ("Feature_ID") REFERENCES Features("Feature_ID"),
    FOREIGN KEY ("Tourist_Attraction_ID") REFERENCES Tourist_Attractions("Tourist_Attraction_ID")
);

Question: Find the the names of the tourist attractions that the tourist named Alison visited but Rosalind did not visit.
SQL: SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Alison" EXCEPT SELECT T1.Name FROM Tourist_Attractions AS T1 JOIN VISITORS AS T2 JOIN VISITS AS T3 ON T1.Tourist_Attraction_ID  =  T3.Tourist_Attraction_ID AND T2.Tourist_ID  =  T3.Tourist_ID WHERE T2.Tourist_Details  =  "Rosalind"

Question: How many tourists did not make any visit?
SQL: SELECT count(*) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )

Question: Count the number of tourists who did not visit any place.
SQL: SELECT count(*) FROM Visitors WHERE Tourist_ID NOT IN ( SELECT Tourist_ID FROM Visits )