Write SQL SELECT commands to answer the following queries using the Delta Airlin

Question

Write SQL SELECT commands to answer the following queries using the Delta Airlines relational database below that is used to keep track of its mechanics, their skills, and their airport locations.

List the names and telephone numbers of all of the mechanics.

List the airports in California that are at least 20 acres in size and have opened in or after 1935.  

List the airports in California that were opened before 1950. Order the results from smallest to largest airport.

Find the average size of the airports in California (Hint: use avg).

How many airports have been open in California in or after 1935? (Hint: use count).

List the names of the mechanics who work in California.

Explanation / Answer

Hi buddy, since you didn't specify table names I assumed reasonably

SELECT name, phone FROM mechanics;
SELECT airport FROM airports WHERE city = 'California' AND area > 20;
SELECT airport FROM airports WHERE opened < 1950 order by area ;
SELECT avg(area) FROM airports;
SELECT count(airport) FROM airports where opened >= 1935;
SELECT name FROM mechanics where workplace = 'California'

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.