For each departure airport, calculate the average occupancy rate of business and economy class flights in August 2017 (according to the actual departure date). Average occupancy is calculated as the percentage of occupied seats out of the total number of seats in a given class. Display the result in three columns:
- departure_airport — departure airport code
- average_business_occupancy — average occupancy rate of business class seats (as a percentage, rounded to two digits)
- average_economy_occupancy — average occupancy rate of economy class seats (as a percentage, rounded to two digits)
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
