Find out the average amount of money

Assignment Help Computer Engineering

Reference no: EM1333301

Consider the 3 tables with these attributes:

TABLE MECHANIC
(
LAST_NAME VARCHAR(50),
BIRTHDATE DATETIME,
PHONE_NO CHAR(10)
)

TABLE AIRPLANE
(
SERIAL_NO CHAR(12),
MODEL VARCHAR(40),
CAPACITY INT
)

TABLE WORKS_ON
(
MECHANIC_LAST_NAME VARCHAR(50),
MECHANIC_BIRTHDATE DATETIME,
AIRPLANE_SERIAL_NO CHAR(12),
CONTRACT_AMOUNT MONEY
)

Write SQL queries to answer the following questions:

(a) Find the last names, birth dates, and phone numbers of all mechanics who have earned at least $50000 from contracts on Boeing 747 airplanes.

(b) Find the average amount of money that it has taken to do maintenance on each different model of jumbo jet (defined to be any airplane model whose capacity is at least 150).

(d) Add to the database, for each DC-9 model airplane,
a DC-10 model airplane with a capacity 50 greater than that of the DC-9 and a serial number the same as that of the DC-9 except with an extra leading "1".

Reference no: EM1333301

Questions Cloud

Explain environmental policy : Explain Environmental Policy and Discuss the relationship between the Interstate Commerece Clause and environmental law

Financial information management evaluate in making decision : Which one of the following is non financial information that management might evaluate in making a decision?

Government actions that create barriers to exit : Government actions that create barriers to exit can have the unintended effect of retarding industrial development.

Necessary variables to form contract : What are the four elements necessary to form a contract? What is the effect of legal capacity on any of the three elements?

Find out the average amount of money : Find out the average amount of money that it has taken to do maintenance on each different model of jumbo jet (defined to be any airplane model whose capacity is at least 150).

Human resource management plan : Human Resource Management Plan - A human resources management plan for a Special Education Teacher employment position

Find expectations that his business will continue to grow : Fernando Culebra has always been fascinated by skateboards. Fernando has won many contests, both locally and nationally. His interest in skateboards led him to open Fernando's Skate Shop in Denton, Maine.

Strategies teams to improve decision making ability : Identify 2 strategies teams can use to improve their decision making ability. Would you argue that different types of decisions require different strategies.

Hr issue within the health care industry : Health Care Administration- HR training - Show training as an HR issue within the health care industry.

User Account

All Pages