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.

MECHNUM MECHNAME MECHANIC Table AIRNAME CITY AIRPORT Table SKILLNUM SKILLNAME SKILL Table QUALIFICATION Table TELEPHONE STATE SKILLCAT YEARQUAL SALARY SIZE PROFIRATE AIRNAME YEAR OPENED

Explanation / Answer

1)Select MECHNAME, TELEPHONE FROM mechanic;
2)select Airname from airport where size>20 and yearopened>=1935;
4) select AVG(size) from airport where Airname='california';
5)select count(Airname) from airport where yearopened>=1935
6)Select mechname, Airname from mechanic where Airname in (select Airname from airport where Airname='california');

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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