Question: 4. (10 pts) Write a SELECT statement that returns four columns from the EQUIPMENT table: a. TotalValue, where TotalValue is the sum of the eqpTotalValue

4. (10 pts) Write a SELECT statement that returns four columns

4. (10 pts) Write a SELECT statement that returns four columns from the EQUIPMENT table: a. TotalValue, where TotalValue is the sum of the eqpTotalValue column b. AverageValue where AverageValue is the average of the eqpTotalValue column c. LowValue where LowValue is the lowest of the eqpTotalValue column d. HighValue where HighValue is the highest of the eqpTotalValue column e. Use appropriate column aliases INFO2411 Advanced Database \& SQL 1 of 2 5. (4 pts) Write a SELECT statement that returns two columns from the EQUIPMENT, eqpNo and eqpTotalValue. Return only three rows, corresponding to the top three total values. Use appropriate column alias names. 6. (5 pts) Write a SELECT statement that returns the empssn, emplast and the number of dependents for each employee with dependents. Sort the results so that the employee with the highest number of dependents is at the top. Use appropriate column alias names. 7. (2 pts) Modify the SELECT statement used in Step 6 to only show those employees with 3 or more dependents. 8. (5 pts) Write a SELECT statement that returns the number of employees that do not have any dependents. Use an appropriate column alias name. The result set should have only 1 column and 1 row

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 a SELECT statement that returns four columns from the EQUIPMENT table: a. TotalValue, where TotalValue is the sum of the eqpTotalValue column b. AverageValue where AverageValue is the average...

9. (10 pts) Write a SELECT statement that returns six columns, based on the eqpTotalValue field in the EQUIPMENT table: a. The eqpDescription should display in the first column b. The original...

1) Write a SELECT statement that returns two columns from the invoices table: vendorID and paymentSum where paymentSum is the SUM () of the paymentTotal column. (Since we have vendorID in the SELECT...

How to query/ write statements for exercise #4-7. See Attached Chapter How to retrieve data from a single table 1 Exercises . Write a SELECT statement that returns three columns from the Vendors...

Learning Activity Two: Retrieving data from a single table Setup [ 1 - 7 ] : Run the create _ ap . sql script to create the database 1 . Write a SELECT statement that returns three columns from the...

Run the create _ ap . sql script to create the database 1 . Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort...

Hello I am using MySQL AP Database. Please help answer questions below. 1. (15 pts) Write a SELECT statement that returns: - the Vendor Name - InvoiceCount: the number of invoices for that Vendor -...

Using the sigma function on the calculator; calculate midpoint : Left end point and Right end point of each given that the value of 77 = 10, 100, 1000, 5000, 10,000

What are the differences between total consideration, total purchase price/enterprise value, and net purchase price? How are these different concepts used?

Short - term debt is particularly attractive to financial managers for all the below reasons except: Group of answer choices It is inexpensive. It is flexible. It is easily available. It does not...

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

4. Assume that as the HR manager, you have decided to prepare some guidelines for supervisors to use when they have to discipline employees. Gather the information needed, using Internet resources...

2. Suppose a coworker just brought you a union leaflet urging employees to sign an authorization card. What questions would you ask of the union supporter? What may happen from this point on?

1. Under what circumstances might a company side with a union in its attempt to organize employees? How would you, as an employee, feel if your employer supported you joining a union?