Extra Tasks
Link to page

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
flight number
sold seats
empty seats
QL015
20
220
TY531
16
294
DP198
7
313
JS177
8
278
KK919
18
358
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
DEPARTFROM
ARRIVEAT
maxCapacity
number of flights
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.