Get a list of airports that have more than one direct flight between them (with different flight_no). Display a table with columns departure_airport_code, arrival_airport_code, flights_count and flight_numbers - sorted array of flight numbers. Sort the results by descending number of flights, then ascending by departure and arrival airport codes.
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
