570
577
27 580
333
183
238
2023-09-14 15:54:47.000 303 2023-03-29 07:03:07.000 181
2023-02-17 05:45:17.000 419
Jim
Bremmell
Edgar Rudolfo Jako Willgress
Male Expedia
Question 5:
Picture 4.1
Write a query to display airline_id, name, NumberOfBookings corresponding to each airline,where NumberOfBookings is the number of bookings having the booking_time in January 2023 of flights of each airline as in the following figure. Order the results in descending order of NumberOfBookings then in ascending order of airline_id for rows having the same NumberOfBookings. Note that NumberOfBookings must be 0 if the corresponding airline has no booking made in January 2023.
5 of 5
Male Expedia
Male Expedia
Paper No: 7
airline id name
5
NumberOfBookings
5
1
Zoom
FUO
Malaysia Airlines
+ 81%
Close
