From the database below, write SQL queries to answer the following questions The entries to the left of the tables (e g A3, L1) are solely for row identification purposes in the questions below and are not part of the logical data of the table Airport Initials (key) Airport Name City State A1 DFW Dallas Ft Worth Dallas TX A2 JFK Kennedy Intl New York NY A3 LAX Los Angeles Intl Los Angeles CA A4 MEM Memphis Memphis TN A5 MIA Miami Intl Miami FL Airport T Table Airline Initials (key) Airline Name HQ City HQ State L1 AA American Airline Dallas TX L2 DL Delta Atlanta GA L3 NW Northwest Minneapolis MN L4 TW Trans World St Louis MO L5 UN United Chicago IL Airline T Table Runway Name (key) Airport Initials (key) Length (Feet) Year Built R1 4 Left MIA 1200 1958 R2 5 Right DFW 1500 1984 R3 5 Right LAX 1500 1984 R4 5 Right MEM 1000 1962 R5 7 Left JFK 1700 1960 R6 7 Left MEM 1500 1989 R7 8 Right LAX 1500 1984 Runway T Table Serial Number (key) Type Capacity Airline Initials Manufacturer P1 01754 747 250 TW Boeing P2 04970 727 130 AA Boeing P3 17594 DC 10 180 AA McDonnell Douglas P4 18113 MD 11 230 NW McDonnell Douglas P5 26040 MD 11 230 UN McDonnell Douglas P6 35891 A320 130 DL Airbus Intl P7 48645 747 220 DL Boeing Airplane T Table Airline Initials (key) Airport Initials (key) Flights per Day First Year S1 AA DFW 160 1978 S2 AA LAX 35 1935 S3 DL DFW 80 1978 S4 DL JFK 40 1952 S5 NW LAX 20 1954 S6 NW MEM 125 1948 S7 TW JFK 45 1957 S8 UN LAX 35 1930 Service T table Write SQL codes to answer the following questions using the table above Questions List the number of flight per day for each airline and then rank them in ascending order of total flight per day What is the oldest runway in Memphis Which aircraft manufacturer might have sold their airplane to American Airline Which airport has the highest traffic in year 1955 (Traffic is measured in a form of total flight per day) Which airline has the highest number of airplane option (airplane type) to choose from Fnd serial numbers of airplanes that belongs to Delta Airline (Do this question by using JOIN not subquery) Convert the code in the previous problem to subquery format Convert the code in the previous problem to subquery format with Exists What is the total number of seats that American Airline has for their planes purchased from Boeing Use Join for this question

The Answer is in the image, click to view ...

Question: From the database below, write SQL queries to answer the following questions. The entries to the left of the tables (e.g. A3, L1) are solely

From the database below, write SQL queries to answer the following questions. The entries to the left of the tables (e.g. A3, L1) are solely for row identification purposes in the questions below and are not part of the logical data of the table.

	Airport_Initials (key)	Airport_Name	City	State
A1	DFW	Dallas-Ft. Worth	Dallas	TX
A2	JFK	Kennedy Intl	New York	NY
A3	LAX	Los Angeles Intl	Los Angeles	CA
A4	MEM	Memphis	Memphis	TN
A5	MIA	Miami Intl	Miami	FL

Airport_T Table

	Airline_Initials (key)	Airline_Name	HQ_City	HQ_State
L1	AA	American Airline	Dallas	TX
L2	DL	Delta	Atlanta	GA
L3	NW	Northwest	Minneapolis	MN
L4	TW	Trans World	St. Louis	MO
L5	UN	United	Chicago	IL

Airline_T Table

	Runway_Name (key)	Airport_Initials (key)	Length (Feet)	Year_Built
R1	4 Left	MIA	1200	1958
R2	5 Right	DFW	1500	1984
R3	5 Right	LAX	1500	1984
R4	5 Right	MEM	1000	1962
R5	7 Left	JFK	1700	1960
R6	7 Left	MEM	1500	1989
R7	8 Right	LAX	1500	1984

Runway_T Table

	Serial _Number (key)	Type	Capacity	Airline_Initials	Manufacturer
P1	01754	747	250	TW	Boeing
P2	04970	727	130	AA	Boeing
P3	17594	DC-10	180	AA	McDonnell-Douglas
P4	18113	MD-11	230	NW	McDonnell-Douglas
P5	26040	MD-11	230	UN	McDonnell-Douglas
P6	35891	A320	130	DL	Airbus Intl
P7	48645	747	220	DL	Boeing

Airplane_T Table

	Airline_Initials (key)	Airport_Initials (key)	Flights_per_Day	First_Year
S1	AA	DFW	160	1978
S2	AA	LAX	35	1935
S3	DL	DFW	80	1978
S4	DL	JFK	40	1952
S5	NW	LAX	20	1954
S6	NW	MEM	125	1948
S7	TW	JFK	45	1957
S8	UN	LAX	35	1930

Service_T table

Write SQL codes to answer the following questions using the table above

Questions

List the number of flight per day for each airline and then rank them in ascending order of total flight per day.

What is the oldest runway in Memphis?

Which aircraft manufacturer might have sold their airplane to American Airline?

Which airport has the highest traffic in year 1955? (Traffic is measured in a form of total flight per day).

Which airline has the highest number of airplane option (airplane type) to choose from?

Fnd serial numbers of airplanes that belongs to Delta Airline. (Do this question by using JOIN not subquery)

Convert the code in the previous problem to subquery format.

Convert the code in the previous problem to subquery format with Exists.

What is the total number of seats that American Airline has for their planes purchased from Boeing. Use Join for this question.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Use the attached code to create and populate ConstructCo Write the SQL queries to answer the following questions based on the ConstructCo database. Save your queries in a text or a Word file and...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

It is just this one question that are good cha Answer the following question based on the following, 5-relation Federal Aviation Administration (FAA) database. Airport Initials, Airline Initials, and...

I do not understand what needs to be done, I've tried to watch the video with no luck. can you help, please? import into MysqL 2A. Under Server Administration on the Home window select the server...

Have additional pictures for this one question 3. Answer the following question based on the following, 5-relation Federal Aviation Administration (FAA) database. Airport Initials, Airline Initials,...

Write SQL queries that answer the questions below (one query per question). The query answers must not contain duplicates, but you should use the SQL keyword distinct only when necessary. For this...

Wrong/copied/incomplete answers will be flagged. Write SQL queries to retrieve data from given tables Consider tables, of a Supplier-Parts DB, shown in Figure 1 Names of tables, columns and...

1 Exercise 3: Lift and Airfoils The first part of this week's assignment is to choose and research a reciprocating engine powered (i.e. propeller type) aircraft. You will further use your selected...

Note that question 2 has 4 different parts Create SQL statements to retrieve the specified data from the following table Consider tables, of a Supplier-Parts DB, shown in Figure 1. Names of tables,...

Your assignment is to develop a database design to solve a real - life data management problem. It can be any problem in your work environment or for another organization, for example, a bookstore (...

Suppose country A undertakes a policy mix of contractionary fiscal policy and expansionary monetary policy. What doyou predict would happen to real interest rates, the value of country As currency,...

A certain gene in one strain of E. coli can be cleaved into fragments of 3 kb and 4 kb using the restriction endonuclease PstI, but it is unaffected by PvuII. In another strain of bacteria, the same...

Show Nazari just purchased a bond that is urreccurcd and is secorndary lo other unsecured bonds with ferpect to interest perymen reparyment at maturity, What type of bond has Shiva purcharsed?

please try to give correct answer 1 7 3 .

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...