5 of 5
Paper No: 9
- NumberOfFlights is the total number of flights operated by the airline.
airline id
4
5
7
8
airlineName
NumberOfFlights
China Eastern Airlines
20
Malaysia Airlines
20
British Airways
24
27
Hong Kong Airlines
10
Singapore Airlines
28
12
American Airlines
22
21
15
16
United Airlines
Emirates Airlines
22
1
2
3
4
5
6
7
8
Question 7:
Picture 6.1
Write a query to display booking_platform_id, booking_platform_name,NumberOfMale Passengers, NumberOfFemale Passengers corresponding to each booking
FUO
Close
+ 100%
Zoom