Question: Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line

Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. The subtotal is a derived attribute calculated by multiplying LINE_UNITS by LINE_PRICE. Sort the output by customer code, invoice number, and product description. Be certain to use the column aliases as shown in the figure.

Figure P7.12 Summary of Customer Purchases with Subtotals CUS_CODE INV_NUMBER 10011 10011 10011 10011 10011

Figure P7.12 Summary of Customer Purchases with Subtotals CUS_CODE INV_NUMBER 10011 10011 10011 10011 10011 10011 10012 10012 10012 10014 10014 10014 10014 10014 10014 10015 10015 10018 P_DESCRIPT 1002 Rat-tail file, 1/8-in. fine 1004 Claw hammer 1004 Rat-tail file, 1/8-in. fine 1008 Claw hammer 1008 PVC pipe, 3.5-in., 8-ft 1008 Steel matting, 4x8x1/6", 5" mesh 1003 7.25-in. pwr. saw blade 1003 B&D cordless drill, 1/2-in. 1003 Hrd. cloth, 1/4-in., 2x50 1001 7.25-in. pwr. saw blade 1001 Claw hammer 1006 1.25-in. metal screw, 25 1006 B&D jigsaw, 12-in. blade 1006 Claw hammer 1006 Hicut chain saw, 16 in. 1007 7.25-in. pwr. saw blade 1007 Rat-tail file, 1/8-in. fine 1005 PVC pipe, 3.5-in., 8-ft Units Bought 2 2 3 1 5 3 5 1 1 1 1 3 1 1 1 2 1 12 Unit Price 4.99 9.95 4.99 9.95 5.87 119.95 14.99 38.95 39.95 14.99 9.95 6.99 109.92 9.95 256.99 14.99 4.99 5.87 Subtotal 9.98 19.90 14.97 9.95 29.35 359.85 74.95 38.95 39.95 14.99 9.95 20.97 109.92 9.95 256.99 29.98 4.99 70.44

Step by Step Solution

★★★★★

3.38 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The below query generates the list of customer purchase... 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 Database Systems Design Implementation Questions!

Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals (as calculated in Problem 12) for each customer....

Using the output shown in Figure as your guide, generate the listing of customer purchases, including the subtotals for each of the invoice line numbers. CUS CODE INV NUMBER P DESCRIPT Units Bought...

Generate a listing of all purchases made by the customers, using the output shown in Figure P7.28 as your guide. ODE | INV-NUMBER | INV-DATE 10011 P DESCRIPT LINE UUNITS LINE PRICE 4.99 1002...

The structure and contents of the Ch07_SaleCo database are shown in Figure P7.9 . Use this database to answer the following problems. 9. Write a query to count the number of invoices. 10. Write a...

11. Generate a listing of all purchases made by the customers, using the output shown in Figure P7.11 as your guide. Sort the results by customer code, invoice number, and product description. 12....

FIGURE P7.9 THE CH07_SALECO DATABASE 10. Write a query to count the number of customers with a balance of more than $500. 12. Using the output shown in Figure P7.12 as your guide, generate a list of...

SQL CODE: /* Introduction to SQL */ /* Script file for SQL Server DBMS */ /* This script file creates the following tables: */ /* VENDOR, PRODUCT, CUSTOMER, INVOICE, LINE */ /* EMPLOYEE, EMP */ /*...

Use the structure and contents of the Ch 0 7 _ SaleCo database used in the class room ( also shown below ) to perform the following using MySQL: Screenshot the Query and the Output for each Question....

29.Using the output shown in Figure P7.29 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. ( Hint: Modify the query format used to...

a. A contract calls for a total payment of $800,000 with a guarantee. Essentially the contractor is guaranteed to make at least $200,000 above his costs. If the contractor can demonstrate his costs...

The Double Helix by James Watson is a first person account of one of the major scientific discoveries of all time. In his book, Watson describes the activities and personalities of his colleagues who...

Consider the following table of net income for a landscaping business: \ table [ [ Year , Sales ] , [ 2 0 1 5 , $ 2 9 4 , 3 7 9

contrast quality management and patient safety, AppendixLO1

What are the key assumptions made by the Hadoop Distributed File System approach?

What is the difference between a name node and a data node in HDFS?

Explain the basic steps of MapReduce processing.

application in cisco Q1. Connect Two Switches, One Hub and Six Computers using star topology in packet tracer also write the procedure in steps.

You make $6,000 annual deposits into a retirement account that pays 10.9 percent interest compounded monthly. How large will your account balance be in 34 years?

Strogue Inc. preferred stock offers annual dividends of $31.65 per share. If you require a rate of return of 8.30%, what is the intrinsic value of the stock? Round to two decimal places (Ex. $0.00).