In this assignment, you will query an airlines database of flight information from the U.S. Bureau of Transportation Statistics Airline On-Time Performance data.

To connect to the MySQL Server, point your client program to:

host: applepie.cx67wtelpwox.us-east-1.rds.amazonaws.com

username: public

password: WAFKGVx3

port: 3306

Questions

1) Use the airlines database to answer the following questions. You need only to submit your SQL code or written responses, not the results returned by the database.

2) Compute the total number of flights that left each of the airports with the word Chicago in their name in 2013, using a JOIN clause. (3 points)

3) Compute the total number of flights that left each of the airports with the word Chicago in their name in 2013, using a subquery. Do you notice a difference in the computation speed? (3 points)

4) Find the model of the specific plane that flew the most flights in 2014. When was that plane manufactured? (4 points)

5) To the extent possible, list the model numbers of the eight planes that flew at least 2200 segments for Southwest Airlines in 2015. (5 points)

6) Among those planes whose year of manufacture is known, list the ten oldest planes used by Delta Airlines in 2015 along with the number of segments they flew in that year. (5 points)

7) The plane with tail number N750AT is a Boeing 757 that was manufactured in 1984. It departed from 22 different airports in 2015. List each airportwith its full nameand the number of flights that this particular plane left from it. (5 points)