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

, show by the Country in asc.
SELECT Country, COUNT(*) FROM airport GROUP BY Country ORDER BY Country
SELECT "Country", COUNT(*) FROM "airport" GROUP BY "Country" ORDER BY "Country"