roomNumber: int
bedNo: int
Picture 1.1
Question 2:
Display all airport in 'United States' or 'United Kingdom' as follows:
3 of 3
Paper No: 7
id code name
1
1 DEN Denver International Airport
2
3
4
5 MCO Orlando International Airport 6 IAD Washington Dulles International Airport United States
5
6
8 IAH George Bush Intercontinental Airport United States
7
15 SEN London Southend Airport 8 16 LHR Heathrow Airport
2 ATL Atlanta Hartsfield-Jackson Airport
4 DFW Dallas/Fort Worth International Airport United States
United States
United States
Georgia
Texas
Florida
Virginia
Texas
United Kingdom Essex United Kingdom Greater London
Washington
Houston
Southend
Hillingdon
country United States
state Colorado
city
Denver
Atlanta
Dallas
Orlando
Picture 2.1
Question 3:
Write a query to select flight_id, departure_time, arrival_time, departing AirportName,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:
234
arrival time
departing AirportName Beijing Daxing International Airport
flight id departure_time 2023-08-27
departingCountry China
14:22:53.000 2023-08-28 05:00:53.000
2023-05-03 19:55:04.000 2023-05-04 11:49:04.000 Beijing Daxing International Airport 2023-11-25 07:18:36.000 2023-11-25 23:12:36.000 Shanghai Pudong International Airport China
China
2023-12-03 03:15:48.000 2023-12-03 17:47:48.000 Beijing Daxing International Airport China
1
5
7
35
41
Zoom
FUO
+ 81%
Close
