Skip to content
Gallery
FLIGHT_DATA
SQA Tasks
Extra Tasks
TABLE DATA
WILD CARD LIKE
More
Share
Explore
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
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
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.