Using the solution of the previous problem rank airports by the number of delayed flights in August 2017 (the fewer the better). Only include airports with more than 100 departures per month. Output the result as a table with columns: airport_rank - airport rating, airport_name - English name of the airport delayed_flights_rate - percentage of delayed flights accurate to two digits. Sort the table by rating
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