Picture 4.1
uestion 5:
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
Booking PlatformName
NumberOfBookings
5
3
2
2
2
1 8
2
3
4
5
6
7
Amadeus
Flight Gorilla
Make my trip
Capterra
At airport
9
Expedia
2
1
0
0
6
2
4
Opodo
8
Trip Ninja
9
5
1
3
7
Cheap Air
Picture 5.1
Question 6:
Zoom
82%
Close
