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]
3 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]3 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
In a case where electrical current leakage from the circuit occurs, the GFCI would do the following:
Jobisdone [24]

Answer:

Sense the current leakage

Trip the circuit

Cut off the electricity

Explanation:

The correct order is -

Sense the current leakage

Trip the circuit

Cut off the electricity

Reason -

First step has to be taken to sense the electric current leakage without it being detected, it cant be dealt with.

The second step consists of tripping the  circuit so at to remove the flow of electricity.

The third step is to Cut the electricity off so to stop the leakage and be safe.

5 0
2 years ago
A machine raises 20kg of water through a height of 50m in 10secs. What is the power of the machine.​
Tomtit [17]

Answer:

hhahhhwghwhwhwhwjwnwjnnnnwnwwnw

Explanation:

jwkwkkwoiwiwiwiwiwowwiwowowiiiiwuuwuwgeevehehsvhsvwhbhhehehwgjjwhwhjwjqwjjuuuwi####!\\\\e

5 0
3 years ago
What is the differences between stack and queue?
Montano1993 [528]

Answer:

A stack is an ordered list of elements where all insertions and deletions are made at the same end, whereas a queue is exactly the opposite of a stack.

Explanation:

7 0
3 years ago
Machine movement can be divided into what two main categories?
pishuonlain [190]

Answer:

motion and power

Explanation:

8 0
3 years ago
Read 2 more answers
4. What are these parts commonly called?
patriot [66]

These parts are commonly called carburetor emulsion tubes. These tubes maintain the air-fuel ratio at different speeds.

The carburetor is a device of the combustion engine power supply system that mixes fuel and air in order to facilitate internal combustion.

The carburetor emulsion tubes are tubes that maintain the air-fuel ratio at different velocities.

These tubes (carburetor emulsion tubes) are small brass cylinders where the metering needle slides into them.

Learn more about carburetors here:

brainly.com/question/4237015

7 0
3 years ago
Other questions:
  • Ammonia gas is diffusing at a constant rate through a layer of stagnant air 1 mm thick. Conditions are such that the gas contain
    14·1 answer
  • A well pumps at 400 L/s from a confined aquifer whose thickness is 24 m. If the drawdown 50 m from the well is 1 m and the drawd
    10·1 answer
  • Air at 20 C and 1 atm flows over a flat plate at 35 m/s. The plate is 75 cm long and is maintained at 60 с. Assuming unit depth
    8·1 answer
  • True or false <br> 19. Closed systems rely on feedback from outside of the system to operate.
    12·1 answer
  • Why did fprtmiu78t7ty87uhyu
    12·1 answer
  • Which of the following activities could be considered unethical?
    7·1 answer
  • Writing an excellent problem statement will not help guide you through the rest of the process and steer you towards the BEST so
    8·1 answer
  • A heating torch is usually referred to as what?<br><br> Stick<br> Flower<br> Rose-bud<br> Lighter
    15·2 answers
  • Which term describes the lowest of a foundation?
    10·1 answer
  • Nonconductive safety shoes can be safely worn in a potentially explosive environment.
    9·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!