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

Plot the total number by grouped by how to get there as a bar graph, and display bar in asc order.
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"