TO SEIN London Southena Airpon
16 LHR Heathrow Airport
Question 3:
Southena
Onned Kingdom cssex
United Kingdom Greater London Hillingdon
Picture 2.1
Write a query to select flight_id, departure_time, arrival_time, departing AirportName,departingCountry corresponding to all flight which departs in the year 2023 from an airport in 'China', where flight_id is the id of the flight, and departingAirportName, departingCountry are respectively the name and the country of the departing airport as follows:
arrival time
departing AirportName Beijing Daxing International Airport China
flight id departure_time
departingCountry
2023-08-27 14:22:53.000 2023-08-28 05:00:53.000
2023-05-03 19:55:04.000 2023-11-25 07:18:36.000
2023-05-04 11:49:04.000 Beijing Daxing International Airport 2023-11-25 23:12:36.000 Shanghai Pudong International Airport China
1
5
2
7
3 35
41
4
5 61
6 83
7 86
90
8
9 94
10 97
11 119
12 127
13 144
14 153
15 187
16 188
17 212
18 231
19 272
20 273
21 298
22 303
23 308
24 330
25 331
China
China 2023-09-01 15:28:23.000 Beijing Daxing International Airport 2023-04-02 02:11:54.000 Beijing Daxing International Airport
China
China 2023-05-05 09:51:59.000 2023-05-05 21:38:59.000 Beijing Daxing International Airport 2023-03-17 07:14:40.000 2023-03-17 23:08:40.000 Shanghai Pudong International Airport China
China
2023-12-03 03:15:48.000 2023-12-03 17:47:48.000 Beijing Daxing International Airport China 2023-03-05 18:26:03.000
2023-03-06 10:20:03.000 Shanghai Pudong International Airport China
2023-06-26 09:05:19.000 2023-03-05 10:29:11.000
2023-06-26 18:41:19.000 Beijing Daxing International Airport China 2023-03-05 22:16:11.000 Shanghai Pudong International Airport China
2023-08-31 23:34:23.000 2023-04-01 11:33:54.000
2023-08-14 22:01:10.000 2023-04-27 20:41:52.000 2023-04-28 12:35:52.000
2023-08-15 12:33:10.000 Shanghai Pudong International Airport China Shanghai Pudong International Airport China
2023-06-18 08:18:11.000 2023-06-18 13:00:11.000 Beijing Daxing International Airport
2023-11-15 09:42:52.000
2023-11-16 01:36:52.000 Shanghai Pudong International Airport China
2023-09-01 17:23:12.000 2023-09-02 05:54:12.000 Shanghai Pudong International Airport China
2023-06-30 06:05:45.000 2023-06-30 20:37:45.000 Beijing Daxing International Airport China 2023-08-22 14:22:03.000 2023-08-22 20:05:03.000 Shanghai Pudong International Airport China
2023-03-06 23:27:04.000 2023-03-07 15:21:04.000 Shanghai Pudong International Airport China
2023-07-09 20:32:32.000 2023-07-10 12:26:32.000 Beijing Daxing International Airport
China
2023-02-17 01:44:30.000 2023-02-17 14:15:30.000 Shanghai Pudong International Airport China
2023-09-07 01:18:48.000 2023-09-07 10:54:48.000 Beijing Daxing International Airport
2023-09-29 12:46:42.000 2023-09-30 04:40:42.000 Beijing Daxing International Airport
2023-02-25 03:04:50.000 2023-02-25 12:40:50.000 Beijing Daxing International Airport
2023-05-20 00:59:50.000 2023-05-20 15:31:50.000 Shanghai Pudong International Airport China
China
China
China
Picture 3.1
Question 4:
Write a query to display booking_id, flight_id, departure_time, passenger_id, first_name,last_name, gender, booking PlatformName corresponding to all bookings which were booked from the booking platform named 'Expedia' of all 'Male' passenger, where booking PlatformName is the name of the booking platform.
Zoom
+ 81%
Close
