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.
airline_id
name
NumberOfBookings
1
5
Malaysia Airlines
5
2
15
United Airlines
5
3
16
Emirates Airlines
5
4
2
China Southern Airlines 3
5
13
Delta Air Lines
3
6
1
Vietnam Airlines
2
7
19
Ryanair UK
2
8
20
Korean Air
2
9 3
China Airlines
1
10
4
China Eastern Airlines
1
11 10
Singapore Airlines
1
12 11
Alaska Airlines
1
13 6
Bangkok Airways
0
14
7
British Airways
0
15 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
Zoom
+ 93%
Close
