Zoom
TO
code name
coury
1
1
DEN Denver International Airport
United States
Colorado
Denver
2
2 ATL Atlanta Hartsfield-Jackson Airport
United States
Georgia
Atlanta
3
4
4 DFW Dallas / Fort Worth International Airport
5 MCO Orlando International Airport
United States
Texas
Dallas
5
6 8 IAH George Bush Intercontinental Airport
IAD Washington Dulles International Airport
6
United States
United States
Virginia
Florida
Orlando
Washington
7
15 SEN London Southend Airport
8
16 LHR Heathrow Airport
United States Texas
United Kingdom Essex
United Kingdom Greater London
Hillingdon
Houston
Southend
Picture 2.1
Question 3:
Write a query to select flight_id, departing_airport, arriving_airport, departure_time,arrival_time, airline Name corresponding to all flights of the airline named 'Vietnam Airlines',where flight_id is the id of the flight and airline Name is the name of the airline operating the flight.
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
20
7
124
18
8 154 17
4
9 197
13
10 315 15
17
3
12
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
Vietnam Airlines
2023-03-04 15:29:52.000
2023-03-05 05:59:52.000 Vietnam Airlines
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 Vietnam Airlines
2024-01-22 02:00:31.000
2024-01-22 18:34: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, departingCountry, arrivingAirportName, arriving Country
+ 119%
Close
