Problem 12Using 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 attributecalculated 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 thefigure.Cus CODEINV NUMBERP DESCRIPTUnits BoughtUnit PriceSubtotal100111002Rat-tail fie, 1/8-in. fine2.004.999.98100111004Claw hammer2.009.9519.90100111004Rat-tail fie, 1/8-in. fine3.004.9914.97100111008Claw hammer1.009.959.95100111008PVC pipe, 3.5-in, 8-ft5.005.8729.35100111008Steel matting, 48x1/6, 5" mesh3.00119.95359.851001210037.25-in. pwr. saw blade5.0014.9974.95100121003B&D cordless drilI, 1/2-In.1.0038.9538.95100121003Hrd. cloth, 1/4-in., 2x501.0039.9539.951001410017.25-in. pwr. saw blade1.0014.9914.99Figure P7.12Task

Query syntax: SELECT column1, column2,...columnNFROM table_name[WHERE][GROUP BY][HAVING][ORDER BY…

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.

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.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...

See similar textbooks

Similar questions

StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.
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.
Alert dont submit AI generated answer. Now you want to focus on the summarizing data for Account Reps hired before 11/2018. Specifically, you want to calculate the total number of Account Reps. In cell J13, insert the COUNTIFS function to calculate the number of Account Reps (cell H9) in the Title column where the date in the Hire Date column was before 1/1/2018. Use relative references for the two criteria range arguments and the title criteria argument in cell H9. Type the date comparison for the second criteria argument. The next step is to calculate the total salary for Account Reps hired before 11/2018. You will use mixed references so that you can later copy the function and change the function name for other calculations. In cell H14, insert the SUMIFS function to calculate the total amount in the Salary column where the Title contains the job title criteria Account Rep (cell H9) and where the date in the Hire Date column was before 1/1/2018. Use relative references for the…
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER_ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2021-12-28 Driving License Checked: True Rating: 4.0
Write a php code to verify the add.employee form based on the following elements: also explain why we need both server and client side validation - All values must not be empty. - Gender values must be either male or female. - Name value must be alphabetic. -ID must be obtained from the department table.
Alter the structure of the table Activities by adding a new column called 'ActivityDescription' of type Varchar2(100). This column will hold the description of each activity.
I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test your trigger COMPLETELY for every event it is defined. (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging). This should work both for new rows and existing rows that are updated. Scenerio: All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.
why is my qryLevelParameter query coming up blank?? Create a new parameter query in Design View based on the tblStates table and the tblSessions table as described below: Add the StateName field from the tblStates table to the query. After the StateName field, add the SessionName, SessionLocation, and Level fields (in that order) from the tblSessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: “Type Primary, Intermediate, or Senior” Run the query, enter Primary when prompted, and then confirm that 17 records are returned.
Modify what you consider to be the best design to include a column called AwardPurchaseAmount. The purpose of this column is to keep a balance of the customers’ purchases for award purposes. Assume that returns will be recorded with invoices having a negative PreTaxAmount. Add a new AWARD table to your answer to part 1. Assume that the new table will hold data concerning the date and amount of an award that is given after a customer has purchased 10 items. Ensure that your new table has appropriate primary and foreign keys. Figure D-1 shows data that James River Jewelry collects for its frequent buyer program.
Repeat Task 5 without using the ITEM_INVOICE VIEW to retrieve the item ID, description, price, invoice number, invoice date, quantity, and quoted price for all items with a quoted price that exceed $100.
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_UNITSS 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. CUs CODE Units Bought INV_NUMBER P_DESCRIPT Unit Price Subtotal Rat-tail file, 1/8-in. fine 10011 1002 2.00 4.99 9.98 10011 1004 Claw hammer 2.00 9.95 19.90 Rat-tail file, 1/8-in. fine 10011 1004 3.00 4.99 14.97 10011 1008 Claw hammer 1.00 9.95 9.95 10011 1008 PVC pipe, 3.5-in., 8-ft 5.00 5.87 29.35 10011 1008 Steel matting, 48'x1/6", .5" mesh 3.00 119.95 359.85 10012 1003 7.25-in. pwr. saw blade 5.00 14.99 74.95 10012 1003 B&D cordless drill, 1/2-in. 1.00 38.95 38.95 10012 1003 Hrd. cloth, 1/4-in., 2x50 1.00 39.95 39.95 10014 1001 7.25-in. pwr. saw blade 1.00 14.99 14.99
Please write a view to list the project name, staff name, and the staff’sbranch city for the staff who are working on the same project more than one time. You should useProject, Staff2, Branch, and Working tables in the dreamhome database. The output column headershould be Project_name, Staff_name, Branch_city. The staff_name should combine fname and lnamewith a space in between.