❤️ Thank you to everyone who supported the project! Last month you donated almost $100 — this keeps the service running free for everyone this month. I hope to count on your support for next month too. Support now →
SQL code copied to buffer
RU PT FR
Task 34:

Find flight occupancy by fare

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.