לחסום wayo
8
Hong Kong Airlines
0
16 9
Air France
0
17 12
American Airlines
0
18
14
Southwest Airlines
0
19 17
Lufthansa Airlines
0
20 18
easyJet
0
Picture 5.1
Zoom
Question 6:
Write a query to display booking_platform_id, booking_platform_name, url,NumberOfBookings corresponding to all booking platforms having less NumberOfBookings than both the two booking platforms named 'Amadeus' and 'Expedia'; where,booking_platform_name is the name of the booking platform and NumberOfBookings is the total number of bookings made via the corresponding platform.
booking platform_id booking_platform_name url
1
1
2
2
3
4
4 5
5 6
Make my trip
Trip Ninja
Cheap Air
Flight Gorilla
Opodo
NumberOfBookings
https://www.makemytrip.com/ 67
https://www.tripninja.io/ 65
https://www.cheapoair.com/ 66
https://flightgorilla.com/ https://www.opodo.com/ 65
Picture 6.1
57
Question 7:
6 of 6
Paper No: 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.
FUO
+ 81%
Close
