Get a list of airports where, based on the results of August 2017, in average of no more than three flights departed and landed per day. Create the resulting table with the columns: airport_code - airport code and flights_count - average daily number of received and departed flights rounded up to the nearest whole number . Sort the results by number of flights, then by airport code.
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
