Skip to content
Extra Tasks

task 1


Display the total seat capacity used for each route with the highest total capacity first.
Include the total capacity, the departure point, arrival point and number of flights on the route

task 2 (challenge)

Display the number of seats sold on each flight along with the number of empty seats.
Empty Seats
0
flight number
sold seats
empty seats
1
QL015
20
220
2
TY531
16
294
3
DP198
7
313
4
JS177
8
278
5
KK919
18
358
6
GR738
4
392
There are no rows in this table
6
Count

task 3 (easy)


How many bookings were for adults travelling alone?

task 4 (challenge)


what was the departure and arrival point for the flights with the highest capacity.
Table 1
0
DEPARTFROM
ARRIVEAT
maxCapacity
number of flights
1
SAW
LHR
396
3
There are no rows in this table
1
Count
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.