Zoom
3
4
6 8 IAH George Bush Intercontinental Airport 6 IAD Washington Dulles International Airport United States United States
7
15 SEN London Southend Airport United Kingdom Essex
DFW Dallas/Fort Worth International Airport
United States
5 MCO Orlando International Airport United States
Texas
Florida
Virginia
Texas
Dallas
Orlando
Washington
Houston
Southend
8 16 LHR Heathrow Airport
United Kingdom Greater London Hillingdon
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 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
13
5 107
6 108 10
7 124
10
19
20
18
8 154
9 197
17
12
4
4
13
17
10 315 15
3
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-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
2023-04-10 07:20:24.000 2023-04-10 18:57:24.000 Vietnam Airlines 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
2023-10-30 00:18:50.000 2023-10-30 04:15:50.000 Vietnam Airlines
Picture 3.1
Question 4:
Write a query to display booking_id, flight_id, departure_time, passenger_id, first_name,
last_name, gender, booking PlatformName corresponding to all bookings which were booked
from the booking platform named 'Expedia' of all 'Male' passenger, where
booking PlatformName is the name of the booking platform.
82%
Close
