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

Show different ways to get to attractions and the number of attractions that can be accessed in the corresponding way Plot them as bar chart, and display from low to high by the X-axis.
SELECT How_to_Get_There, COUNT(*) FROM Tourist_Attractions GROUP BY How_to_Get_There ORDER BY How_to_Get_There
SELECT "How_to_Get_There", COUNT(*) FROM "Tourist_Attractions" GROUP BY "How_to_Get_There" ORDER BY "How_to_Get_There"