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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a new table, EMP_PROMOTION to store the employees information. You must use a subquery to create the new table. Make the salary column invisible. Display the structure of the table in SQL Developer. Also use a SELECT statement to display all records from the new table EMP_PROMOTION.
CREATE TABLE employees8(employee_id NUMBER(10) PRIMARY KEY,first_name VARCHAR(25) UNIQUE,last_name VARCHAR(25) UNIQUE,job_id NUMBER(3),salary NUMBER(6) NOT NULL,department_name VARCHAR2(20));CREATE TABLE jobs8(job_id NUMBER(3) PRIMARY KEY,job_title VARCHAR2(25),min_salary NUMBER(4)check(min_salary >=2900),max_salary NUMBER(6)check(max_salary<=100000)); CREATE TABLE departments8(department_id NUMBER(2) PRIMARY KEY,department_name VARCHAR2(30),location_name VARCHAR2(15) DEFAULT 'Istanbul'); how can I do this question according to these 3 tables ? Create a complex view that joining with three tables.
Reference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT table, increase the price of each item in category BRD by five percent. (Hint: Multiply each price by 1.05.) In the NONCAT table, increase the length of the DESCRIPTION column to 40 characters.
Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description. This is what Ive been working with and doesn't give me results, just error messages. SELECT R.CreditDescription, E.CustomerID FROM Encounter E JOIN Customer C ON E.CustomerID = C.CustomerID JOIN CreditRating R ON C.CreditID = R.CreditID WHERE E.EncDate = STR_TO_DATE('2015-07-05','2015-07-12','2015-07-19','2015-07-26'); ORDER BY creditrating.creditid, ASC; creditrating creditid creditdescription minfico maxfico comments customer customerid cfirstname clastname…
In our dataset, each job has a predefined salary range. Expand on the previous query and explore this salary range per customer. The query should display the attributes as problem 1 but also include the name of their position, and salary ranges for each employee. Finally, add a column that calculates the difference between each employee’s current salary and the base (minimum) salary for their job. Renamed this last calculated field as “Pay_above_minimum”.
Problem 15, Need help please. Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made by each customer. Your output values must match those shown in Figure P7.15. Sort the results by customer code.
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
please use input variable for live sql and explain the code
4 and 5
Generate a listing of all purchases made by the customers, using the output shown below as your guide. Sort the results by customer code, invoice number, and product description.
please answer all 2.4, 2.5 ,2.6 and 2.7
Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.