Queries

1.For each aircraft type included in the database, show the name (ACName) and maximum range. Order results from greatest range to least.

2.For each airport included in the database that is above 40 degrees north latitude, show the IATA Code, city name (CityShortName), and the airport turnaround time. Results should be ordered alphabetically (by CityShortName).

3.Which flights in June had 20 or fewer passengers on board? For each, show the date, flight number, origin code, destination code, and number of passengers. Order results by date, then by origin code alphabetically.

4.For each aircraft used by the company, show the tail number, the acquisition date, the name of the manufacturer, the type name (ACName), the number of coach seats (ACYSeats), and its cruising speed. Order results by tail number (lowest to highest).

5.Which ERJ 175 flights that departed on Tuesdays in June 2015 were full? For each full flight, list the date, flight number, IATA codes for origin and destination, and the number of passengers on board. Order results by date and then alphabetically by origin code. (The ERJ 175 is configured to hold 78 passengers.)

6.Make a "departures board" for OKC that shows all morning flights on June 26, 2015. The output should include, for each OKC departure, only the following: the flight number, the destination name (use CityLongName), the scheduled time of departure, and the aircraft type used (use ACName). Results should be ordered from earliest to latest.

7.make a query with the data you think is most important for an operations manager to see every morning. Describe what the query and why you think it is the most important.

\f