3 of 3
Paper No: 5
1
1 DEN Denver International Airport
2
2 ATL Atlanta Hartsfield-Jackson Airport
3
4
5
6
8 IAH George Bush Intercontinental Airport
7
15 SEN London Southend Airport
8
16 LHR Heathrow Airport
id code name
4 DFW Dallas / Fort Worth International Airport
5 MCO Orlando International Airport
6 IAD Washington Dulles International Airport
country
United States
United States
United States
United States
United States United States
state
city
Colorado
Denver
Georgia
Atlanta
Texas
Dallas
Florida
Orlando
Virginia
Washington
Texas
Houston
United Kingdom Essex
United Kingdom Greater London Hillingdon
Southend
Picture 2.1
Question 3:
Write a query to select flight_id, departing_airport, arriving_airport, departure_time,arrival_time, airlineName 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
17
10 315 15
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-05 05:59:52.000 Vietnam Airlines
2023-03-04 15:29:52.000
2023-09-10 05:20:52.000
2023-09-10 11:06:52.000 Vietnam Airlines
2023-05-07 11:48:01.000 2023-04-10
2023-05-07 21:24:01.000 Vietnam Airlines Vietnam Airlines
07:20:24.000 2023-04-10 18:57:24.000
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 04:15:50.000 Vietnam Airlines
2023-10-30 00:18:50.000
2023-10-30
Picture 3.1
Zoom
Question 4:
+ 110%
Close
