3
7
British Airways
24
4
8
Hong Kong Airlines
27
5
10
Singapore Airlines
28
6
12
American Airlines
22
7
15
United Airlines
21
8
16
Emirates Airlines
22
Picture 6.1
Question 7:
Write a query to display booking_platform_id, booking_platform_name,NumberOfMale Passengers, NumberOfFemale Passengers corresponding to each booking platform where NumberOfMale Passengers and NumberOfFemale Passengers are respectively the number of distinct male passengers and female passengers who made bookings for flights to fly from 'Germany' to another country via the corresponding booking platform as in the following figure.
booking_platform_id
booking_platform_name
NumberOfMale Passengers NumberOfFemale Passengers
Make my trip
1
1
2
2
Trip Ninja
0
4
0
3
3
3
Capterra
3
2
4
4
Cheap Air Flight Gorilla
3
3
5
5
2
5
6
6
Opodo
4
2
7
7
At airport
1
5
8 8
Amadeus
1
5
9 9
Expedia
3
5
Picture 7.1
Zoom
FUO
Question 8:
Create a stored procedure named P1 to calculate the number of bookings made by a given
+ 113%
Close
