Description
-
Write a query to list the distinct flight numbers of all flights from New York to Chicago by American Central Airlines Inc. on Sundays.
-
Find the number of flights from New York to Chicago by different Airlines in a week in descending order.
-
Print the names of all airlines that ever flew more than 1,000 flights in a single day (No Duplicates).
-
Print the names of all airlines that ever flew less than 10,000 flights in a week (No Duplicates).
-
Print the names of all airlines and their cancellation rate in descending order that had cancellation rate more than 0.75% of their flights out of Chicago canceled.
-
Find the day of the week with the longest average arrival delay. Return the name of the day and the average delay.
-
Write a query to list all cities that cannot be reached from New York through a direct flight but can be reached with one stop (i.e., can be reached with two flights).
-
Write a query to list all cities that can neither be reached from New York through a direct flight nor with one stop (i.e., can be reached with three or more flights).
-
Find all origin cities that only serve flights shorter than 4 hours. Return only the names of the cities. List each city only once in the result.
-
Print the airlines, month number, and summation of their arrival delays in each month, whose arrival delay is greater than 50 at least once.
-
Write a query to output unique flight numbers of flights whose tail number ends with letter “D”.
-
Considering only even days of a month, write a query to output the count of flights that travel a distance greater than 600 kms to reach Arizona.
-
Write a query to find the average number of flights that reach between 3:00 pm to 6:00 pm to the state Colorado in each month.
-
Print each airline and the longest distance traveled by it, along with the origin and destination, in ascending order of the distance.
-
Write a query to output “DestStateFips”, “DestStateName” of destinations whose destination state name starts with the letter “S”.
-
Write a query to find the flight number whose departure delay is highest in each month.
-
Get the names of all airlines which had more than 3 diverted flights in a month.
-
Get flight numbers and airline name of flights which were diverted from San Francisco, CA (i.e. Had destination SFO but were diverted to some other airport).
-
Find the day of the week which has the most number of cancellations.
-
Get the flight date, airline name and origin airport of flights that were delayed due to weather.