Zoom
3 of 3
Paper No: 10
id code name
2 ATL Atlanta Hartsfield-Jackson Airport
DFW Dallas/Fort Worth International Airport
5 MCO Orlando International Airport
1
1 DEN Denver International Airport
2
3
4
4
5
6
8 IAH
George Bush Intercontinental Airport
7
15 SEN
London Southend Airport
8
16 LHR
Heathrow Airport
6 IAD Washington Dulles International Airport
country
United States
state
city
Colorado
Denver
United States
Georgia
Atlanta
United States
Texas
Dallas
United States
Orlando
Virginia
Washington
United States
Houston
Southend
United States
Florida
Texas
United Kingdom Essex
United Kingdom Greater London Hillingdon
Question 3:
Picture 2.1
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 airlineName 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
5 107
10
13
19
arrival time
airlineName
2023-05-03 19:55:04.000 2024-01-21 17:51:51.000
2023-05-04 11:49:04.000 Vietnam Airlines
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
+ 82%
Close
