roomNumber: Int
bedNo: int
Question 2:
Picture 1.1
Display all airport in 'United States' or 'United Kingdom' as follows:
3 of 3
Paper No: 5
id code name
1 DEN Denver International Airport
1
country United States
state
Colorado
city Denver
Atlanta
Dallas
Orlando
2 ATL Atlanta Hartsfield-Jackson Airport United States
Georgia
4 DFW Dallas / Fort Worth International Airport United States Texas
5 MCO Orlando International Airport
United States
Florida
6 IAD Washington Dulles International Airport United States Virginia
Washington
Houston
Southend
8 IAH George Bush Intercontinental Airport United States Texas
15 SEN London Southend Airport United Kingdom Essex
16 LHR Heathrow Airport
United Kingdom Greater London Hillingdon
3
4
5
6
8
Question 3:
Picture 2.1
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
+ 95%
Zoom
Close
