Question: 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

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 (AIRNAME), and skill number (SKILLNUM) are all unique fields. SIZE is an airports size in acres. SKILLCAT is a skills 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 mechanics proficiency rating in a particular skill. Cell minus directions - Week 3 for LMS.jpg Write SQL SELECT commands to answer the following queries. 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!

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

Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number, airport name, and skill number are all...

Best Airlines, Inc., data warehouse: In the exercises in Chapter 8, we saw the following relational database, which Best Airlines uses to keep track of its mechanics, their skills, and their airport...

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

PART 1 : Airline DB ( 1 0 points ) Consider the following Airline DB that keeps track of mechanics, their skills, and their airport locations. Snapshot of Airline DB Note: Mechanic Number ( MECHNUM )...

We are increasingly seeing new trends in application of emerging technologies, such as blockchain, audit analytics and continuous auditing, artificial intelligence and others in the public sector....

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

How can you summarize the compensation and reward system of the three organizations? What do they all have in common, if anything? Look up everything you can find that has been written about Lincoln...

Below is the BOOK income statement of the McCandles General Partnership: Sales COGS GP Dividend income Gain on sale of stock Gain on sale of equipment Interest income on US T-Bills Interest income on...

Let u(t) = 2ti+ (t- 1)j-8k. Compute the derivative of the following function. %D (114 + 21) u(t) Select the correct choice below and fill in the answer box(es) to complete your choice. Di+Dj+ [ O A....

To determine the realized return on an investmen, the investor needs to know income received the cost of an investment the sale price of the investment 1 and 2 1 and 3 2 and 3 atl of the above

Do you mind showing your work? Thanks! OBJ. 4 The condensed income statement for the Consumer Products Division of Bantastic Industries Inc. is as follows (assuming no service department charges)...

5. Develop a self-management module for a training program.

6. Allow employees to take time off from work to acquire knowledge, study problems, attend training, and use technology.

1. Use technology, e-mail, and social networking sites (such as Facebook or MySpace) or portals on the company intranet that allow people to store information and share it with others.