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 NUMBER, altitude NUMBER, 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 NUMBER)

What is the id, name and IATA code of the airport that had most number of flights?
SELECT T1.id, T1.name, T1.iata FROM airport AS T1 JOIN flight AS T2 ON T1.id = T2.airport_id GROUP BY T2.id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."id", "T1"."name", "T1"."iata" FROM "airport" "T1" JOIN "flight" "T2" ON "T1"."id" = "T2"."airport_id" GROUP BY "T2"."id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY