Question: 14. Create a SQL program to show which job class has the highest total project charges. SELECT jobclass.job_class_code, ROUND(SUM(hourly chargeout rate hours charged), 2)

14. Create a SQL program to show which job class has the highest total project charges. SELECT jobclass.job_class_code, ROUND(SUM(hourly chargeout rate hours charged), 2) AS Project Charges FROM assignment, project, jobclass, employee WHERE assignment.proj_num= project.proj_num AND assignment.emp num = employee.emp_num AND GROUP BY job class code ORDER BY project charges DESC; Result Grid *83832888 SA BE DA employee.job_class_code-jobclass.job_class_code AD GS Result Grid PR job dass_code b. Write the code and insert the answer for the highest average charges? Your answer should look like this job dass_code DD DD 8382838 SA DA GS Fter Rows! Project Charges 18490.50 16834.50 3924. 13 3910.53 2011.10 1787.50 1391.69 591.14 695.84 595.83 591.14 Fiber Rowst Average Project Charges 4622.62 3366.90 2011.10 1962.06 1303.51

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

It appears that youve shared a screenshot of a SQL exercise that includes two parts a A SQL query th... View full answer

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 Programming Questions!

A company has 410,000 basic shares outstanding and a current stock price of $4000. A financial buyer decides to offer a 65% premium to the current share price. Calculate the equity purchase price in...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

On January 1, 2010, Elaine Company purchased for $600,000, a trademark with an estimated useful life of 16 years. In January 2014, Elaine paid $90,000 for legal fees in a successful defense of the...

Database Management system Instructions Print the lab assignment and do all the questions given below, on a paper. . Q.1 00 JOB 00 ASSIGNMENT ASSIGN NUM ASSIGN_DATE PROJ_NUM EMP_NUM ASSIGN_JOB...

Objectives: learn to use the IN and NOT IN operators and the wildcard search operator. Along with a derived value as a column in a result set. For this assignment we will be using the emp table. Open...

PS3 Objectives: learn to use the IN and NOT IN operators and the wildcard search operator. Along with a derived value as a column in a result set. For this assignment we will be using the emp table....

Written in Oracle apex (SQL) 1. Create a file called ps5a.sql script. Write a SQL query that displays the employee number, employee name, manager and job for all employees that have a manger with the...

Hi this is a databse question. This is a part of the big question. Please answer all of them as this is the third time i am posting. this is sql language. do not use other programming languages 11....

Solve for the remaining angles and side of the triangle described below. Round to the nearest thousandth: B = 45, c = 6, a = 5 Answer How to enter your answer (opens in new window) b = | C = A Keyboa

The images are in sequence and are not individual questions. I wanted to clarify that because I know policy is to only answer one question, but please share the proper code as I have started on the...

A solid nonconducting sphere of radius R carries a uniform charge density throughout its volume. At a radial distance r 1 = R /4 from the center, the electric field has a magnitude E 0. What is the...

Dangerous Overseas Assignment Case StudyOn June 2 4 , 1 9 9 8 , Edward Leonard of Creston, British Columbia, a diamond driller workingfor Terramundo Drilling Inc. ( Terramundo ) was kidnapped by...

1. Explain the Customer-Supplier Duality in Service Supply Relationships Diagram.

Based on the scenario mentioned in the article, there are several recommendations I would give to the stakeholders to restore the preferred situation 1 . Sales Team: Explanation: The sales team...

1) Calculate average stress and strain generated in each component of the figure shown below and use ANSYS to evaluate same (CAD model for same is assignment3.sat, uploaded in canvas). Geometry...

Fresh Harvest is a new startup by 2 young entrepreneurs who are both passionate about sustainable agriculture and believed that this is viable potential business. Their aim is to address food...

Intro A new project is expected to generate annual sales of $170,000 and annual costs of $161,500 Annual depreciation attributable to the project is $60,000. The marginal tax rate is 34%. Part 1 |...

Use a calculator to evaluate the expression. Round your result to the nearest thousandth. V (32 + #)

Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...

Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...

John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...

At January 1, 2005, the available-for-sale securities portfolio held by Howe Corporation consisted of the following investments: 1. 2,500 shares of Nester common stock purchased for $42 per share. 2....

A monopolistic competitive firm has demand and cost curves given by: QD = 1000 - 2P TC = 5,000 + 50Q a. At what price should this firm sell its product? b. What do you think would happen as the firm...

Georgia Company has condensed income statements as follows: REQUIRED: Prepare a horizontal analysis of Georgia Company's income statements. Comment on the trends, both favorable and unfavorable.