Support ongoing development - donate to help us maintain and improve the platform. 🖥️ Support sqltest →
SQL code copied to buffer
Task 36:

Flight Occupancy by Fare Class

PostgreSQL
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)
Expected result Columns: 3 · Rows: 104
departure_airport average_business_occupancy average_economy_occupancy

Sample rows open after wrong checks: 0 of 3

Write your query below and click "Check it!". Tables are described in the right pane.

The query result will appear here. Ctrl+Enter - Run query

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

Privacy & Cookie Policy.