SQLeasySubqueries~12m

AeroMax Airlines wants to identify all flights that had passenger bookings...

Problem

AeroMax Airlines wants to identify all flights that had passenger bookings exceeding the average booking count across all flights for the same aircraft type. For each qualifying flight, return the flight number, departure airport code, aircraft type, and the actual booking count.

Examples

Example 1

Constraints

›Return flight_number, departure_airport, aircraft_type, and booking_count columns
›Only include flights with booking counts above the average for their aircraft type
›Order results by flight_number

Reference solution

Reference solution available after you attempt the question.

Ready to solve it?

Start a session on Mockbit #52. Write your SQL, run it against real data, and get graded on correctness, efficiency, query structure, and business understanding.