1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
olya-2409 [2.1K]
2 years ago
14

Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airpo

rt locations. Mechanic number (MECHNUM), airport name (AIRNAME), and skill number are all unique fields. SIZE is an airport’s size in acres. SKILLCAT is a skill category, such as an engine skill, wing skill, tire skill, etc. YEARQUAL is the year that a mechanic first qualified in a particular skill; PROFRATE is the mechanic’s proficiency rating in a particular skill.
Write SQL SELECT commands to answer the following queries.

a. List the names and ages of all the mechanics.

b. List the airports in California that are at least
20 acres in size and have been open since 1935.
Order the results from smallest to largest airport.

c. List the airports in California that are at least 20
acres in size or have been open since 1935.

d. FindtheaveragesizeoftheairportsinCalifornia
that have been open since 1935.

e.e. How many airports have been open in California since 1935?
f. How many airports have been open in each state since 1935?
g. How many airports have been open in each state since 1935? Include in your answer only those states that have at least five such airports.
h. List the names of the mechanics who work in California.
i. Fan blade replacement is the name of a skill. List the names of the mechanics who have a proficiency rating of 4 in fan blade replacement.
j. Fan blade replacement is the name of a skill. List the names of the mechanics who work in California who have a proficiency rating of 4 in fan blade replacement.
k. List the total, combined salaries of all of the mechanics who work in each city in California.
l. Find the largest of all of the airports.

m. Find the largest airport in California

MECHANIC Table MECHNUM MECHNAME AGE SALARY Ab SALARY AIRPORT Table AIRNAME CITY STATE SIZE YEAROPENED

images
Engineering
1 answer:
Musya8 [376]2 years ago
6 0

Answer:

Explanation:

A)

SELECT MECHNAME,AGE FROM MECHANIC;

B)

SELECT AIRNAME,SIZE FROM AIRPORT WHERE SIZE>=20 AND STATE='CALIFORNIA' AND YEAROPENED >=1935 ORDER BY SIZE ASC;

C)

SELECT AIRNAME,SIZE FROM AIRPORT WHERE (SIZE>=20 OR YEAROPENED >=1935) AND STATE='CALIFORNIA';

D)

SELECT AVG(SIZE) FROM AIRPORT WHERE STATE='CALIFORNIA' AND YEAROPENED >=1935;

E)

SELECT COUNT(AIRNAME) FROM AIRPORT WHERE STATE='CALIFORNIA' AND YEAROPENED >=1935;

F)

SELECT COUNT(AIRNAME),STATE FROM AIRPORT WHERE YEAROPENED>=1935 GROUP BY STATE;

G)

SELECT COUNT(AIRNAME),STATE FROM AIRPORT WHERE YEAR OPENED>=1935 GROUP BY STATE HAVING COUNT(*)>=5;

H)

SELECT MECHNAME FROM MECHANIC A JOIN AIRPORT B

ON A.AIRNAME=B.AIRNAME AND B.STATE='CALIFORNIA';

I)  

SELECT MECHNAME FROM MECHANIC A

JOIN QUALIFICATION B

ON A.MECHNUM=B.MECHNUM

AND B.PROFRATE=4

JOIN SKILL C

ON B.SKILLNUM=C.SKILLNUM

AND SKILLNAME='FAN BLADE RELACEMENT';

J)  SELECT MECHNAME FROM MECHANIC A

JOIN QUALIFICATION B

ON A.MECHNUM=B.MECHNUM

AND B.PROFRATE=4

JOIN SKILL C

ON B.SKILLNUM=C.SKILLNUM

AND SKILL NAME='FAN BLADE REPLACEMENT'

JOIN AIRPORT D

ON A.AIRNAME=D.AIRNAME

AND STATE='CALIFORNIA';

K)   SELECT SUM(SALARY),CITY FROM MECHANIC A

JOIN AIRPORT B

ON A.AIRNAME=B.AIRNAME

AND STATE='CALIFORNIA'

GROUP BY CITY;

L)   SELECT MAX(SIZE) FROM AIRPORT ;

M)  SELECT MAX(SIZE) FROM AIRPORT WHERE STATE='CALIFORNIA';

You might be interested in
Primary mental skills needed for riding a motorcycle
Irina-Kira [14]

Answer:

You have to know the basic mechanics to help you correctly use the motorcycle, and you also have to have the right mindset - knowing you can ride it, and having determination. All of these factors are the primary mental skills you need for riding a motorcycle.

5 0
2 years ago
Select the correct answer.<br> Which equation gives you the amount of work performed?
Fantom [35]

Answer:

Hello

this is the answer

5 0
3 years ago
Which of the following can effect LRO?
aleksley [76]

Answer:

The lunar radiation environment, allowing scientists to determine potential impacts to astronauts and other life. It also will test models on the effects of radiation and measure radiation absorption by a type of plastic that is like human tissue. The results could aid in the development of protective technologies to help keep future lunar crew members safe. CRaTER was built and developed by Boston University and the Massachusetts Institute of Technology in Boston.

7 0
2 years ago
The first thing you should do is develop a ____________________ to determine what vehicle you can afford.
swat32

The first thing you should do is develop a <u>budget</u> to determine what vehicle you can afford.

<h3>What is an automobile?</h3>

An automobile is also referred to as a vehicle, car or motorcar and it can be defined as a four-wheeled vehicle that is designed and developed to be propelled by an internal-combustion (gasoline) engine, especially for the purpose of transportation from one location to another.

<h3>What is a budget?</h3>

A budget can be defined as a financial plan that is typically used for the estimation of revenue and expenditures of an individual, business organization or government for a specified period of time, often one year.

In this context, we can reasonably infer and logically deduce that the first thing anyone should do is to develop a <u>budget</u> in order to determine what vehicle they can afford.

Read more on budget here: brainly.com/question/13964173

#SPJ1

7 0
1 year ago
What is the name of the first federation vessel in star trek hint 17?
Nitella [24]

Answer:

The Fesarius

Explanation:

It's the first vessel

7 0
2 years ago
Other questions:
  • a refrigerator uses refrigerant-134a as the working fluid and operates on the vapor-compression refrigeration cycle. the evapora
    10·2 answers
  • A long homogeneous resistance wire of radius ro = 5 mm is being used to heat the air in a room by the passage of electric curren
    15·1 answer
  • Saturated water vapor undergoes a throttling process from 1bar to a 0.35bar. What is the change in temperature for this process?
    10·1 answer
  • A wooden cylinder (0 02 x 0 02 x 0 1m) floats vertically in water with one-third of ts length immersed. a)-Determine the density
    7·1 answer
  • I'm really bad at measurements so I don't understand this.
    12·1 answer
  • 10. True or False: You should select your mechanic before you experience vehicle failure.
    6·2 answers
  • 4 Error-Correcting Polynomials (a) Alice has a length 8 message to Bob. There are 2 communication channels available. When n pac
    6·1 answer
  • 5 kg of a wet steam has a volume of 2 m3
    8·1 answer
  • WARNING:<br><br> when people put links in the answer it is a virus DO NOT DOWNLOAD IT
    15·2 answers
  • Which statement is true about the future of space travel?
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!