Question
please correct my answer.
Problem 7.8 1 SELECT SUM (ASSIGN_HOURS) AS SumOfASSIGN_HOURS, SUM(ASSIGN_CHARGE) AS SumOfASSIGN_CHARGE FROM ASSIGNMENT, Probl
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution :-

Your solution is correct but end the statment use semicolon(;). Except that remain all statement is correct.

SELECT SUM(ASSIGN_HOURS) AS SumofAssignHours, SUM(ASSIGN_CHARGES) AS SumofAssignCharges FROM ASSIGNMENT;

Here is my explanation. If you have any qurie,please comment. If you satisfy with this solution, please like the solution. Thank you.

Add a comment
Know the answer?
Add Answer to:
please correct my answer. Problem 7.8 1 SELECT SUM (ASSIGN_HOURS) AS SumOfASSIGN_HOURS, SUM(ASSIGN_CHARGE) AS SumOfASSIGN_CHARGE FROM...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The Ch07_ConstructCo database stores data for a consultingcompany that tracks all charges to projects. The...

    The Ch07_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch07_ConstructCo database are shown in Figure P7.1.Note that the ASSIGNMENT table in Figure P7.1 stores the JOB_CHG_HOUR values as an attribute (ASSIGN_CHG_HR) to maintain historical accuracy of the data. The JOB_CHG_HOUR values are likely to change over time. In fact, a JOB_CHG_ HOUR change will be...

  • the problem is in the first photo but when i try to code the problem and...

    the problem is in the first photo but when i try to code the problem and get the solution i get a 0% am o doing something wrong? need help Edit View History Bookmarks People Tab Window Help х Mind Tap - Cengage MindTap - Cengage Learning arse Modules: Summer 202 X ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=5829622314511297 WeteransUnited... HOA PAYMENT M JOHNNY EMAIL: fi... M KATIE EMAIL: flor... EDDE CENGAGE MINDTAP Programming Exercise 2.3 Instructions Study Tools fivestar.py 1 new=int(input 2 oldvint(input 3 total=(new...

  • Please need serious and professional help! Hello! I am working on an "object oriented analysis and...

    Please need serious and professional help! Hello! I am working on an "object oriented analysis and design" Project. I would really need your sincere help in creating a vision document for this project. The Things That I require in the "vision document" is: 1. Product Overview [This section provides a high level view of the product capabilities, interfaces to other applications, and system configurations. This section usually consists of three subsections, as follows: •          Product perspective •          Product functions •         ...

  • If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...

    If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...

  • Please answer all PROBLEM 1 A three-litre four-stroke diesel engine develops 12 kW per m3 of...

    Please answer all PROBLEM 1 A three-litre four-stroke diesel engine develops 12 kW per m3 of free air inducted per minute. The volumetric efficiency is 82 % at 3600 rpm referred to atmospheric condition of 1 bar and 27 oC. A rotary compressor which is mechanically coupled to the engine is used to supercharge the engine. The pressure ratio and the isentropic efficiency of the compressor are 1.6 and 75 % respectively. Calculate the percentage increase in brake power due...

  • problem 3-1 please answer inside the chart. Draw + Design Layout References View Mailings Review Help...

    problem 3-1 please answer inside the chart. Draw + Design Layout References View Mailings Review Help Awigancats 160 44 6 50 145 20 165 192 Comprehensive Problems Neto e Chapter 3 Honorkadets below to solve problems 3/ how 3.3. Extreme Edge, Inc Income Sun For the Years Hinded December 31, 2013, 2012 and 2011 (5 in thousands) Accounts payable Accueities Total current liabilities Long-term has Notes payable Total Liabilities 100 350 100 265 100 40 50 410 2011 2013 51.340...

  • Problem 12-5 Total fixed expenses 019.279 Income (loss) from operations 1-46,000 -19,275 Your answer is correct....

    Problem 12-5 Total fixed expenses 019.279 Income (loss) from operations 1-46,000 -19,275 Your answer is correct. What course of action do you recommend for each division? Division 1 Division 11 Continued Eliminated Your answer is partially correct. Try again. Prepare a columnar condensed income statement for Sarasota Company, assuming Division Illis eliminated. Division II's unavoidable fixed costs are allocated equally to the continuing divisions. then enter the amount using either a negative sign preceding the number -45 or parentheses g....

  • please answer both questions Problem 1. Selected accounts from the ledger of Hughes Company appear below....

    please answer both questions Problem 1. Selected accounts from the ledger of Hughes Company appear below. For each account, indicate the following: (a) In the first column at the right, indicate the nature of each account, using the following abbreviations: Revenue - R Asset - A Liability - L Expense - E Capital/Equity- In the second column, indicate the increase side of each account by inserting Dr. or Cr. (b) Increase Side Type of Account Account Supplies (2) Notes Receivable...

  • Need help with comprehensive project (PLEASE MAKE SURE CHECK TOTALS ARE CORRECT) TIA!!! T- Accounts Adjusted...

    Need help with comprehensive project (PLEASE MAKE SURE CHECK TOTALS ARE CORRECT) TIA!!! T- Accounts Adjusted Trial Balance Income Statement Statement of Retained Earnings Balance Sheet Closing Entries Post-closing trial balance Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2016. Given on the first two tabs are ABC's 12/31/16 Unadjusted Trial Balance and a list of needed adjustments. 1. Make all 12 adjustments on the...

  • Case Study 3: Driving Ari Fleet Management with Real-Time Analytics Automotive Resources International®, better known as...

    Case Study 3: Driving Ari Fleet Management with Real-Time Analytics Automotive Resources International®, better known as simply ARI®, is the world's largest privately-held company for vehicle fleet management services. ARI is headquartered in Mt. Laurel, New Jersey and has 2,500 employees and offices throughout North America, Europe, the UK, and Hong Kong. The company manages more than 1,000,000 vehicles in the U.S., Canada, Mexico, Puerto Rico and Europe. Businesses that need vehicles for shipments (trucks, vans, cars, ships, and rail...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT