Zoom
110
255
2023-04-01 03:16:50.000 259
Hercule
124
175
2023-05-17 08:35:15.000 419
Rudolfo
Dumbreck Male
Expedia
Willgress Male
Expedia
145
11 198
344
208
12 217
13 255
14 271
295
314
152
15 304
88
16 307
53
2023-03-16 19:38:55.000 135
2023-03-16
09:50:56.000 237
2023-07-11 13:37:33.000 63
2023-09-24 06:34:48.000 321
2023-06-13 05:03:13.000 27 2023-04-08 18:49:41.000 448
2023-07-15
11:10:49.000 323
Josias
Claremont Male Expedia
Lionel
Taree
Eugene
Durrans
Male
Expedia
Male Expedia
Frankie
Bourdon
Borg
Creswell
Male Expedia
Male
Expedia
Evyn
Muro
Male Expedia
Obadias
Itzkov
17 329
186
2023-06-04 23:35:22.000 235
Peter
18 345
181
19 367
20 402
21 459
22 475
23 505
24 517
25 570
26 577
27 580
193
130
338
254
298
270
333
183
238
2024-01-30
21:02:41.000 217
2023-08-01 08:12:33.000 481
2023-07-20 01:14:16.000 294
Jervis
2023-12-12
07:17:17.000 235
2023-11-09 20:34:25.000 423
2023-02-17 01:44:30.000 53
2023-10-25 18:48:14.000 231
2023-09-14 15:54:47.000 303
2023-03-29 07:03:07.000 181
2023-02-17 05:45:17.000 419
Peter
Chadd
Male Expedia
Dutteridge Male
Expedia
Dorow
Domenico
Missington
Male
Expedia
Skipton
Hevey Male Dutteridge Male
Expedia Expedia
Adamovitch
Male
Expedia
Male
Expedia
Arther
Ainsbury
Male
Expedia
Beaufort
Slyman Bremmell Male
Male Expedia
Jim
Expedia
Edgar
Jako
Male
Expedia
Rudolfo
Willgress
Male
Expedia
Picture 4.1
Question 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
1
8
2
5
3
1
4
3
5
7
+ 82%
Amadeus
5
Flight Gorilla
3
Make my trip
2
Capterra
2
At airport
2
Close
