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,

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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....

SQL Introduction Consider the following relational database that Delta Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number (MECHNUM), airport name...

Instructions Answer the following questions related to the Happy Cruise Lines company (refer to Minicase 1 on page 17). Each question should be answered using proper rules of grammar, punctuation,...

MINICASES PORT PORTUNE COUNTRY DOGS SANCH Skole NORAS CLIENUM CONRY SPOLE PASSER 1. Consider the following relational database for Happy Cruise Lines. It keeps track of ships, crulsos, ports, and...

Hello, I have a homework, the question is attached. Overview of the SQL language. Data preparation: the Extraction, Transformation and Loading (ETL) process. Data Warehouse, Data Governance. Grand...

I need help on g-i PORT Toble PORTNAME COUNTRY NUNDOCKS MAMAGER VISIT Table CRUISENUM PORTNAME COUNTRY ABRDATE DEPDATE PASSENGER Toble . 1. Consider the following relational database for Happy Cruise...

2. Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For...

Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A "cruise" is a particular sailing of a ship on a particular date. For...

Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A \"cruise\" is a particular sailing of a ship on a particular date. For...

Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports and passengers. A "cruise" is a particular sailing of a ship on a particular date. For...

For June lily corp estimated sales revenue at 610000 it pays sales commissions that are 5% of sales the sales managers salary is 255000 estimated shipping expenses total 1.5% of sales and...

The pay rates for 3 people were the following numbers of dollars per hour: 8, 10.5, and 7. In Mexican pesos (if the exchange rate is 10 pesos per dollar), these pay rates are 80, 105, and 70 pesos...

In the event of a defoult on one side of a futures trade, Multiple Choica the clearing member becomes the defauting anhic the clearing member is sued by the detiuntig party. Today's settiement price...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

c. How is trust demonstrated?

Have issues been prioritized?

d. How will lack of trust be handled?