3 of 3
Paper No: 7
id code name
1 DEN Denver International Airport
2 ATL Atlanta Hartsfield-Jackson Airport
country
state
city
United States
United States
Denver
Colorado
Georgia
Texas
Atlanta
3 4 DFW Dallas/Fort Worth International Airport United States
4
5
Dallas
5 MCO Orlando International Airport United States
Florida
Virginia
Orlando
6 IAD Washington Dulles International Airport United States
Washington
8 IAH George Bush Intercontinental Airport 7 United Kingdom Essex
6
United States
Texas
United Kingdom Greater London Hillingdon
Houston
15 SEN 16 LHR London Southend Airport Heathrow Airport
Southend
1
2
Picture 2.1
8
Question 3:
Write a query to select flight_id, departure_time, arrival_time, departingAirportName,departingCountry corresponding to all flight which departs in the year 2023 from an airport in 'China', where flight_id is the id of the flight, and departing AirportName, departingCountry are respectively the name and the country of the departing airport as follows:
flight id departure_time
arrival time
departing AirportName
departingCountry
81%
Zoom
