CREATE TABLE operate_company (id DECIMAL, name TEXT, type TEXT, principal_activities TEXT, incorporated_in TEXT, group_equity_shareholding DECIMAL)
CREATE TABLE flight (id DECIMAL, vehicle_flight_number TEXT, date TEXT, pilot TEXT, velocity DECIMAL, altitude DECIMAL, airport_id DECIMAL, company_id DECIMAL)
CREATE TABLE airport (id DECIMAL, city TEXT, country TEXT, iata TEXT, icao TEXT, name TEXT)

how many airports are there in each country?
SELECT COUNT(*), country FROM airport GROUP BY country
SELECT COUNT(*), "country" FROM "airport" GROUP BY "country"