flight id departing_airport
arriving_airport
departure_time
1 7
7
4
2
16
10
14
3 18
16
17
4
66
15
13
5 107
10
19
6 108
10
7
124 18
20
12
8 154 17
4
9 197
13
17
10 315 15
3
arrival time
airlineName
2023-05-03 19:55:04.000
2023-05-04 11:49:04.000 Vietnam Airlines
2024-01-21 17:51:51.000 2024-01-21 21:33:51.000 05:59:52.000 Vietnam Airlines
Vietnam Airlines
2023-03-04 15:29:52.000 2023-03-05
2023-09-10 05:20:52.000 2023-05-07 11:48:01.000
2023-09-10 11:06:52.000 Vietnam Airlines 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 18:34:31.000 Vietnam Airlines
2024-01-22 02:00:31.000
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, departing Country, 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 arrivingCountry 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; departingAirportName and departingCountry are respectively the name and the country of the departing airport; and arrivingAirportName and arrivingCountry are respectively the name and the country of the arriving airport.
fight id departure time
24
2
72
anival sme
airlineName
2023-03-30 01:44:46.000 2023-03-30 11:20:46.000 United Airlines
2023-06-06 10:41:39.000 2003-06-06 20:17:39.000 Bangkok Airways
89
2023-04-18 23:30:34.000 2023-04-19 09:06:34.000 British Airways
104 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
141
204
267
277
279
10 201
11 306
330
13 344
14 346
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 2003-02-28 12:27:20.000 Southwest Airlines
2023-06-07 15:28:13:000 2003-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 2003-06-09 06:32:33.000 Lufthansa Airlines
departing AirportName
Denver International Airport
Adanta Hartsfield-Jackson Airport
Denver International Airport
Adarta Hartsfield-Jackson Airport
Orlando International Airport
departing Country anivingAirportName
LUnited States
Adanita Hartsfield-Jackson Airport
United States
Orlando International Airport
Orlando International Airport
United States
United States
United States
aniving Country
United States
United States
United States
Washington Dulles International Airport
United States
United States
Adarta Hartsfield-Jackson Airport
Adarta Hartsfield-Jackson Airport
United States
Orlando International Airport
United States
George Bush Intercontinental Airport United States
Washington Dulles International Airport
Denver International Airport
Atlanta Hartsfield-Jackson Airport
Dallas/Fort Worth International Airport United States
United States
United States
United States
United States
George Bush Intercontinental Airport
Dallas/ Fort Worth International Airport United States
United Kingdom London Southend Airport
United Kingdom
George Bush Intercontinental Airport United States
Heathrow Airport
Beijing Daxing International Airport
Adarts Hartsfield-Jackson Airport
George Bush Intercontinental Airport
China
United States
United States
Shanghai Pudong Intermational Airport China
George Bush Intercontinental Airport
Denver International Airport
United States
United States
Question 5:
Zoom
108%
Picture 4.1
Close
