4 of 4
Paper No: 9
Write a query to display flight_id, departure_time, arrival_time, airlineName,departing AirportName, departingCountry, arrivingAirportName, arrivingCountry
corresponding to all flights having the departure_time from the 1st January 2023 to the 30th June 2023 and in which the departing Country is the same as the arriving Country as in the following figure. Note that flight_id is the id of the flight; airlineName is the name of the airline which operates the flight; departingAirportName and departing Country are respectively the name and the country of the departing airport; and arrivingAirportName and arrivingCountry are respectively the name and the country of the arriving airport.
fight id departure time
anival Sime
airineName
2023-03-30 01:44:46.000 2023-03-30 11:20:46.000 United Airlines
2023-06-06 10:41:30.000 2023-06-06 20:17:39.000 2023-04-18 23:30:34.000 2023-04-19 09:06:34.000
Bangkok Airways British Airways
2023-06-20 03:33:21.000 2023-06-20 13:09:21.000 Alaska Airlines
14
2023-05-13 08:08:53.000 2023-05-13 17:44:53.000 Korean Air
20 2023-05-06 13:53:36.000 2023-05-06 23:29:36.000 American Airlines
26
2023-04-15 20:34:41.000 2023-04-16 06:10:41.000 British Airways 2023-02-28 02:51:20.000 2023-02-28 12:27:20 000 Southwest Airlines
27
279 2023-06-07 15:28:13.000 2023-06-08 01:04:13.000 Ryanair UK
2023-02-26 14:00.000 2023-02-26 23:50:00.000 Delta Air Lines 2023-04-10 09:27:44.000 2023-04-10 19:03:44.000 Hong Kong Airlines
2023-02-25 03:04:50.000 2023-02-25 12:40:50.000 China Eastern Airlines
2023-03-16 19:38:55.000 2023-03-17 05:14:55.000 American Airlines
2023-06-08 20:56:33.000 2023-06-09 06:32:33.000 Lufthansa Airlines
281
30
330
344
346
departing AirportName
Denver International Airport Adanta Hartsfield Jackson Airport
Denver International Airport
Adanta Hartsfield-Jackson Airport Orlando International Airport
departing Country anivingAirportName
United States Adanta Hartsfield-Jackson Airport
United States
Orlando International Airport
United States
Orlando International Airport
United States
United States
George Bush Intercontinental Airport United States
Washington Dulles International Airport United States Denver International Airport
United States
United States
George Bush Intercontinental Airport United States Aldarta Hartsfield Jackson Airport
Heatfvow Airport
Beijing Desing International Airport Adanta Hartsfield-Jackson Airport
George Bush Intercontinental Airport
amiving Country
United States
United States
United States
Washington Dulles International Airport United States
Dallas/Fort Worth International Airport United States
Adanta Hartsfield Jackson Airport
Adanta Hartsfield-Jackson Airport
United States
United States
Orlando International Airport
George Bush Intercontinental Airport United States
Dallas/Fort Worth International Airport United States
United Kingdom London Southend Airport
China
Shanghai Pudong International Airport China
United States
George Bush Intercontinental Airport
United States
Denver International Airport
United States
United States
United States
United Kingdom
Question 5:
Picture 4.1
Zoom
Write a query to display Booking Platformld, Booking PlatformName, NumberOfBookings corresponding to each booking platform; where NumberOfBookings is the number of bookings made by Female passengers in April 2023 (based on booking_time). Display the results in descending order of NumberOfBookings then in ascending order of
Booking Platformld for rows having the same NumberOfBookings. Note that
+ 100%
Close
