CREATE TABLE airport_codes (
iata CHAR (3) PRIMARY KEY NOT NULL,
icao CHAR (4) UNIQUE,
name VARCHAR (255) NOT NULL,
city VARCHAR (255),
locality VARCHAR (255),
country CHAR (2) NOT NULL
);
--- IATA ICAO Airport name City Locality Country
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAA', 'KAAA', 'Logan County Airport', 'Lincoln', 'Illinois', 'US');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAA', 'NTGA', 'Anaa Airport', 'Anaa', 'Tuamotu Island', 'PF');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAB', 'YARY', 'Arrabury Airport', 'Arrabury', 'Queensland', 'AU');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAC', 'HEAR', 'El Arish International Airport', 'El Arish', '', 'EG');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAD', '' , 'Ad-Dabbah Airport', 'Ad-Dabbah', '', 'SD');
INSERT INTO airport_codes ("iata", "icao", "name", "city", "locality", "country")
VALUES ('AAE', 'DABB', 'Rabah Bitat Airport (Les Salines Airport)', 'Annaba', '', 'DZ');