Question 5:
Zoom
Write a query to display Booking Platformld, Booking PlatformName, NumberOfBookings corresponding to each booking platform; where NumberOfBookings is the number of bookings made by Female passengers in April 2023 (based on booking_time). Display the results in descending order of NumberOfBookings then in ascending order of Booking Platformld for rows having the same NumberOfBookings. Note that NumberOfBookings must be 0 if there is no booking made in April 2023 by Female passengers via the corresponding platform.
Booking Platformld
8
5
1
3
7
9
6
2
4
Booking PlatformName
NumberOfBookings
5
3
2
2
2
2
1
0
0
1
2
3
4
5
6
7
8
9
Amadeus
Flight Gorilla
Make my trip
Capterra
At airport
Expedia
Opodo
Trip Ninja
Cheap Air
Picture 5.1
Question 6:
Write a query to display airline_id, airlineName, NumberOfFlights corresponding to the airlines having more NumberOfFlights than all the three airlines named 'Vietnam Airlines','Air France' and 'Lufthansa Airlines'; where, for each airline:
airline_id and airlineName are respectively the id and the name of the airline.
FUO
Close
+ 100%
