For each airport, find a list of destination and departure airports. Create the resulting table with the columns: airport_code - airport code, departures_to - array of destination airport codes and arrivals_from - array of departure airport codes. Sort both arrays in alphabetical order. Sort the result by the first column.
Write your request in the field below and click the "Check it!" button.
Use PostgreSQL syntax to write your answer. Descriptions of tables are provided at the bottom of the screen.
ER diagram of the Bookings database
