CREATE TABLE airport (id NUMBER, City CLOB, Country CLOB, IATA CLOB, ICAO CLOB, name CLOB)
CREATE TABLE operate_company (id NUMBER, name CLOB, Type CLOB, Principal_activities CLOB, Incorporated_in CLOB, Group_Equity_Shareholding FLOAT)
CREATE TABLE flight (id NUMBER, Vehicle_Flight_number CLOB, Date CLOB, Pilot CLOB, Velocity FLOAT, Altitude FLOAT, airport_id NUMBER, company_id NUMBER)

List the number of airports in each country with a bar chart ordered alphabetically by the name.
SELECT Country, COUNT(Country) FROM airport GROUP BY Country ORDER BY name
SELECT "Country", COUNT("Country") FROM "airport" GROUP BY "Country" ORDER BY "name"