14. Create a SQL program to show which job class has the highest total project charges....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
It appears that youve shared a screenshot of a SQL exercise that includes two parts a A SQL query th... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these 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...
-
The species-area curve tells us that slowing or halting___________ ___________ will potentially slow the rate of extinction.
-
Consider an electron orbiting a proton and maintained in a fixed circular path of radius R = 5.29 x 10-11 m by the Coulomb force. Treating the orbiting charge as a current loop, calculate the...
-
For Andrew's Electronic Instruments, calculate the interest coverage and net profit ratio. Is Andrew's business healthy? Income Statement for Andrew's Electronics for End of Year2004 (thousands)...
-
TMP Human Resource Consulting had the following contribution margin income statement for the year ended 2025. Required Answer each of the following independent situations. (a) Explain how an...
-
Statement of Financial Position Adjustment and Preparation, the adjusted trial balance of Eastwood Company and other related information for the year 2010 are presented below. Additional information:...
-
1 Given functions g(x) = and m(z) 2-4, state the domains of the following functions using Interval notation. Domain of 9(2) m(2) Domain of g(m(a)): Domain of m(g(x)) :
-
You are a staff accountant preparing your first Form 1120 for your first client, SageGreen Computer Corporation. Your manager plans to review your prepared tax form each step of the way, starting...
-
Arndt, Incorporated reported the following for 2024 and 2025 ($ in millions): Revenues Expenses 2024 $ 942 798 2025 $ 1,034 Pretax accounting income (income statement) Taxable income (tax return) $...
-
Although the court does not deem it necessary to give an opinion on the issue in this case, several district courts have ruled that Title VII prohibits discrimination against a worker based upon the...
-
Research the different processes involved during the planning phase of a project. Identify the tasks and techniques associated with each of these processes. Prepare diagram where you relate...
-
How do social identities such as race, gender, class, and nationality intersect with power dynamics, producing complex systems of privilege and oppression that shape individuals' life chances and...
-
Normal and inferior goods are differently impacted by recessions. Examples include new cars versus fast food. The textbook examples include jewelry, gourmet pet food, dollar general stores. For this...
-
How do technological advancements, particularly in the realms of surveillance, communication, and information control, influence the exercise and contestation of power in contemporary society ?
-
At First Street Elementary School, about 25% of the 640 students ride bicycles to school. About how many students ride bicycles to school?
-
The rate at which the temperature of an object changes is proportional to the difference between its own temperature and the temperature of the surrounding medium. Express this rate as a function of...
-
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...
-
The hydrodynamic boundary layer equations consist of one momentum equation and the continuity equation. How does one solve for the pressure?
-
In laminar flow, why does the heat transfer coefficient decrease as the boundary layer thickness grows?
-
How does the hydrodynamic boundary layer thickness depend upon the Reynolds number?
Study smarter with the SolutionInn App