Report the value of each canceled order for each customer. Sort by customer name and order number.
Fantastic news! We've Found the answer you've been seeking!
Question:
Report the value of each canceled order for each customer. Sort by customer name and order number.
based on the ClassicModels
Transcribed Image Text:
Payments check Number ◆paymentDate amount customerNumber Customers customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country sales RepEmployeeNumber creditLimit customerLocation Orders orderNumber orderDate requiredDate shipped Date → status comments customerNumber HI Offices officeCode city phone addressLine1 addressLine2 state country postalCode territory officeLocation Employees employeeNumber lastName firstName extension email reports To job Title officeCode Order Details orderNumber productCode quantity Ordered priceEach >orderLineNumber ProductLines productLine > textDescription H Products productCode productName →productScale → productVendor →productDescription quantity InStock buy Price → MSRP productLine Payments check Number ◆paymentDate amount customerNumber Customers customerNumber customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country sales RepEmployeeNumber creditLimit customerLocation Orders orderNumber orderDate requiredDate shipped Date → status comments customerNumber HI Offices officeCode city phone addressLine1 addressLine2 state country postalCode territory officeLocation Employees employeeNumber lastName firstName extension email reports To job Title officeCode Order Details orderNumber productCode quantity Ordered priceEach >orderLineNumber ProductLines productLine > textDescription H Products productCode productName →productScale → productVendor →productDescription quantity InStock buy Price → MSRP productLine
Expert Answer:
Answer rating: 100% (QA)
Select Sum quantity ordered price each Ordervalue Customernumber ... View the full answer
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date:
Students also viewed these databases questions
-
A budget consists of accounting of what has been spent and how much is left a plan for spending for the coming year income, expenses, and assests such as buildings and equipment a list of income and...
-
For the credit card account below, compute the average daily balance, the finance charge, and the account balance for the next billing. Assume the cycle ends on the same date each month and that the...
-
Salespeople are paid more than just about everyone in the company. This compensation difference can create jealousy, particularly among those who don't trust salespeople anyway and think salespeople...
-
The mass-to-charge ratio for the positive ion F+ is 1.97 107 kg/C. Using the value of 1.602 1019 C for the charge on the ion, calculate the mass of the fluorine atom. (The mass of the electron is...
-
A physical pendulum is positioned so that its centre of gravity is above the suspension point. From that position the pendulum started moving toward the stable equilibrium and passed it with an...
-
Graph y = mx + b and y = -1/m x + b simultaneously in the same coordinate system for b fixed and several different values of m, m 0. Describe the apparent relationship between the graphs of the two...
-
Identify three objects for an ATM system.
-
Shanahan Corporation produces three types of media: CDs, DVDs, and double-layer DVDs. Shanahan purchases cases for the media from a firm in Mexico and purchases the labels from another supplier in...
-
Definition 0.2 Suppose that G = (V,E) is a connected graph. The diameter of G is 8(G)= max d(x, y) x,yV 4. For this question assume that G is not a complete graph (a graph has 8(G) = 1 iff G is...
-
Fourth-Sixth-Twelfth Bank currently pays an annuall dividend of $1.40 per share. After extensive analysis, you forecast that the Bank's stock will continue to pay the $1.40 dividend for four years....
-
How much steel (in 3 ) will be required to form the part below if the radius of the cylinder is 6", the height is 4" and the dimensions of hole is 3" x 3"? h X X
-
Go to the Web. Locate your states criminal statutes. Examine your states gun control laws. In your judgment, are these laws too permissive or too restrictive? Are any of these statutes susceptible to...
-
Go to the web. Locate your states criminal statutes (or another states if yours are not available online). Determine whether your state uses Model Penal Code terminology (purposely, knowingly,...
-
Go to http://www.findlaw.com/casecode/supreme.html. Locate the Supreme Courts decision in United States v. Ramirez, decided March 4, 1998. Read the decision. Write a brief summary of the decision in...
-
Use www.findlaw.com or some other Internet resource to locate the U.S. Supreme Courts most recent decisions in the areas of arrest and interrogation. Try to determine whether the Court has agreed to...
-
Go to the Court TV website at http://www.courtv.com. Follow Court TVs coverage of a current trial. Write a memorandum to your instructor summarizing the major factual and legal issues before the...
-
Given the IR and HNMR of Meso-HydroBenzoin. Please give a detailed assignment of the peaks for the compound. IR Spectra of Meso-Hydrobenzoin: HNMR Spectra of Meso-Hydrobenzoin: Relative Transmittance...
-
When you weigh yourself on good old terra firma (solid ground), your weight is 142 lb. In an elevator your apparent weight is 121 lb. What are the direction and magnitude of the elevator's...
-
Why is data not lost when invoices and purchase orders are purged?
-
What do the terms 2/10, n/30 mean?
-
What information is provided on a corporations income statement that is not contained on a sole proprietorship or partnership income statement?
-
Management is considering three alternatives to satisfy an urgent need. Each of the alternatives will completely satisfy the need, so no combinations have to be considered. The first costs, operating...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/ year. a. Determine the MIRR for this project. b. Is this project economically...
Study smarter with the SolutionInn App