4
66
15
13
5 107
10
19
6
108
10
20
7
124
18
8
154
17
4
9 197
13
17
10 315
15
3
12
2023-09-10 05:20:52.000 2023-09-10 11:06:52.000 Vietnam Airlines
2023-05-07 11:48:01.000
2023-05-07 21:24:01.000
Vietnam Airlines
2023-04-10 07:20:24.000
2023-04-10 18:57:24.000
Vietnam Airlines
2023-02-16 19:27:57.000
2023-02-17 08:20:57.000
Vietnam Airlines
2024-01-22 02:00:31.000 2024-01-22 18:34:31.000 Vietnam Airlines
2023-04-01 21:54:04.000
2023-04-02 09:42:04.000
Vietnam Airlines
2023-10-30 00:18:50.000
2023-10-30 04:15:50.000
Vietnam Airlines
Picture 3.1
Question 4:
Write a query to display flight_id, departure_time, arrival_time, airlineName,departingAirportName, departingCountry, arrivingAirportName, arrivingCountry
corresponding to all flights having the departure_time from the 1st January 2023 to the 30th June 2023 and in which the departingCountry is the same as the arriving Country as in the following figure. Note that flight_id is the id of the flight; airlineName is the name of the airline which operates the flight; departing AirportName and departing Country are respectively the name and the country of the departing airport; and arrivingAirportName and arriving Country are respectively the name and the country of the arriving airport.
fight id departure time
1
24
2
72
3
89
4
5
6
104
141
204
7
8
267
277
9 279
10 281
11 306
12 330
13 344
14 346
arrival time 2023-03-30 01:44:46.000 2023-03-30 11:20:46.000
airlineName United Airlines
2023-06-06 10:41:39.000 2023-04-18 23:30:34.000
2023-06-06 20:17:39.000 2023-04-19 09:06:34.000
Bangkok Airways British Airways
2023-06-20 03:33:21.000 2023-06-20 13:09:21.000 Alaska Airlines
2023-05-13 08:08:53.000 2023-05-13 17:44:53.000 Korean Air
2023-05-06 13:53:36.000 2023-05-06 23:29:36.000 American Airlines
2023-04-15 20:34:41,000 2023-04-16 06:10:41.000 British Airways
2023-02-28 02:51:20.000 2023-02-28 12:27:20.000 Southwest Airlines
2023-06-07 15:28:13.000 2023-06-08 01:04:13.000 Ryanair UK
2023-02-26 14:14:00.000 2023-02-26 23:50:00.000 Delta Air Lines
2023-04-10 09:27:44.000 2023-04-10 19:03:44.000 Hong Kong Airlines
2023-02-25 03:04:50.000 2023-02-25 12:40:50.000 China Eastern Airlines
2023-03-16 19:38:55.000 2023-03-17 05:14:55.000 American Airlines
2023-06-08 20:56:33.000 2023-06-09 06:32:33.000 Lufthansa Airlines
departing AirportName
Denver International Airport
Atlanta Hartsfield-Jackson Airport
Denver International Airport
Atlanta Hartsfield-Jackson Airport
Orlando International Airport
George Bush Intercontinental Airport
Washington Dulles International Airport
Denver International Airport
Allarta Hartsfield-Jackson Airport
George Bush Intercontinental Airport
Heathrow Airport
Beijing Daxing International Airport
Adanita Hartsfield-Jackson Airport
George Bush Intercontinental Airport
departing Country arrivingAirportName
United States
United States
United States
arriving Country
United States
Atlanta Hartsfield-Jackson Airport
Orlando International Airport
Orlando International Airport
United States
United States
United States
Washington Dulles International Airport
United States
United States
Dallas/Fort Worth International Airport United States
United States
Atlanta Hartsfield-Jackson Airport
United States
United States
United States
Atlanta Hartsfield-Jackson Airport
Orlando International Airport
United States
United States
United States
George Bush Intercontinental Airport
United States
United States
United States
United Kingdom
China
United States
United States
Dallas/Fort Worth International Airport
London Southend Airport
Shanghai Pudong International Airport
George Bush Intercontinental Airport
Denver International Airport
United Kingdom
China
United States
United States
Question 5:
Zoom
+ 124%
Picture 4.1
Close
