Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free.Support →
SQL code copied to buffer
Task 36:

Flight Occupancy by Fare Class

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)

Use PostgreSQL syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.