6- Create a query to produce the total purchase per invoice, generating the results shown below, sortedby invoice number. The invoice total is the sum of the product purchases in the LINE that corresponds tothe INVOICE.INV_NUMBER| Invoice Total100124.9410029.981000153.85100434.87100570.441005397.83100734.971008399. 157- Write a query to produce the number of invoices and the total purchase amounts by customer, usingthe output shown in Figure below as your guide. The results are sorted by customer code.CUS CODE Number of levoices | Total Customer Purchases444.00153 85422 771001110012100141001534 971001870 448- Write a query to generate the total number of invoices, the invoice total for all of the invoices, thesmallest of the customer purchase amounts, the largest of the customer purchase amounts, and theaverage of all the customer purchase amounts. The output must match Figure below.Total Invoices Tota Sales Minimum Customer Purchases Largest Oustorner Purceses Average Oustorner Purcheses11 26 0334 97444 00225 21 Given a small company database tables below. Create the database and tables for the company andanswer all the questions below.LINECUSTOMERVENDORINV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICECus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCEV_CODEV_NAMEV_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER10003 23100-HB0.0510010 RamasAfred015844-257321225 Bryson, Ine.Smithson015223-3234 TN10064 89-WRE-Q256.0010011 DunneLeona713804-123821220 SuperLoo, Inc.Flushing04215-8006 FLN1 13-Q2/P2214.00100710012 SmithKathy015804-2205345.8821231 DSE SupplySingh815228-3246 TN1007254778-2T4.0010013 OlowskiPaul815804-2100530.7521344 Gomez Bros.Ortega815889-2546 KYN10081 PVC23DRT5.8710014 OrlandoMyronle15222-187222507 Dome SupplySmith01e78-1419 GAIN10082 WR3/TT33110.0510015 OBrianAmy713442-338123110 Randsets Ltd.Anderson001078-3008 GA10083 23100-HB0.0510010 BrownJames015297-1228221.1924004 Brackman Bros. Browning615228-1410 TNIN10017 WiliamsGeorge015290-2556788.924288 JORDVA, Inc.Hakford815e08-1234 TNPRODUCT10018 FarissAnne713382-718525443 BAK, Inc.904227-0003 FL216.55SmithP_CODEP_DESCRIPTP_INDATE P_QOHP_MIN P_PRICE P_DISCOUNT V_CODE10019 Smith015207-380025501|Damal Supplies Smythe015e90-3529 TNINOlette11QER/31 Power painter, 15 psi, 3-nozzle03-Nov-17100.000.002550525505 Rubicon Systems Orton904450-0002 FL13-02/P2 7.25-in. pwr. saw blade13-Dec-17321514.000.05 21344INVOICE14-Q1/L3 9.00-in. pwr. saw blade13-Nov-17181217.400.00 21344LINEINV_NUMBER CUS_CODE INV_DATE1548-002 Hrd. cloth, 14-in. 2x500.00 2311015-Jan-181530.95INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE100110014 10-Jan-181558-QW1 Hrd. cloth. 1/2-in. 3x500.00 2311915-Jan-182343.0010011 13-Q2/P214.001100210011 10-Jan-182232/QTY BAD igsaw, 12-in, blade30-Dec-17100.0280.052428810012 23100-HB19.05100310012 16-Jan-182232/QWE BAD jgsaw, B-in. blade24-Deo-1700.870.05242881002154778-2T4.00100410011 17-Jan-182238/OPD B&D cordless drill, 1/2-in.20-Jan-181238.950.052550510031 2238/QPD38.05100510018 17-Jan-1823100-HB Ciaw hammer20-Jan-1823109.050.102122510032 1546-Q02139.05100010014 17-Jan-1823114-AA Sledge hammer, 12 Ib.02-Jan-18814.40.0510033 13-02/P2514.90100710015 17-Jan-1854778-2T Rat-tail fie. 1/8-in. fine15-Dec-174.901004154778-2T3.4.0043200.0021344100810011 17-Jan-189.0580-WRE-Q Hicut chain saw, 10 in.07-Feb-1810042 23109-HB211256.000.052428810051 PVC23DRT12PVC23DRT PvC pipe. 3.5-in., 8-A20-Feb-18188755.870.005.87PRODUCT10061 SM-1827730.00SM-18277 1.25-in. metal screw, 2501-Mar-180.00 21225172756.00P CODEP DESCRIPTPINDATE P_QOH P_MIN P_PRICEP_DISCOUNT V_CODE10062 2232/QTY1109.92sw-23116 2.5-in, wd. screw. 5024-Feb-18237 1008.450.00 21231WR3TT3 Steel matting. 4x8x1/8". 5" mesh 17-Jan-18185119.950.10 2560625595

Actually, SQL is a language to operate databases in searching and filtering the data according to…

6- Create a query to produce the total purchase per invoice, generating the results shown below, sorted by invoice number. The invoice total is the sum of the product purchases in the LINE that corresponds to the INVOICE. INV NUMBER Invoice Total 1001 24.94 1002 9.98 1003 153.85 34.87 1004 1005 70.44 1006 397.83 1007 34.97 1008 399. 15 7- Write a query to produce the number of invoices and the total purchase amounts by customer, using the output shown in Figure below as your guide. The results are sorted by customer code. CUS CODE Number of lovoices | Total Customer Purchases 444 00 153 85 422 77 34 97 10011 10012 10014 10015 10018 70 44

6- Create a query to produce the total purchase per invoice, generating the results shown below, sorted by invoice number. The invoice total is the sum of the product purchases in the LINE that corresponds to the INVOICE. INV NUMBER Invoice Total 1001 24.94 1002 9.98 1003 153.85 34.87 1004 1005 70.44 1006 397.83 1007 34.97 1008 399. 15 7- Write a query to produce the number of invoices and the total purchase amounts by customer, using the output shown in Figure below as your guide. The results are sorted by customer code. CUS CODE Number of lovoices | Total Customer Purchases 444 00 153 85 422 77 34 97 10011 10012 10014 10015 10018 70 44

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

Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.
Write a Query using JOINS to display the Customer Name, Email, Delivery Address and Final Price of all orders whose Final Price is atleast 200 dollars.
3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.
Create a query for displaying first name of employees whose Initial is 'A' using instr() function.
Write a query that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in CUSTOMER table, call this CUSTOMER_NAME), Phone number of ALL Customers (based on CUS_AREACODE and CUS_PHONE in CUSTOMER table, call this CUSTOMER_PHONE), for those haven’t flied before (based on the record in CHARTER table).
Challenge 1 v= Ⓒ Challenge #1 - Part 5 Task Determine what the sale price would be for each item if the Marketing team went off the rails and implemented a sale for 35% off the original price of all items! Once again, add this new column onto the end of your existing query and name it discount_35. ► Want a hint? III = query.sql + 1 SELECT *, original_price* (1 0.35) AS discount_35 2 FROM retail.products; 42442 3 5 product_id sku CT- BLK- 8 1 SQL Viewer 2 CT- BLK- 8.5 X + Cap Toe - Cap Toe product_type color size full_name category material created_at black 8.0 black 8.5 Cap Toe - Black - 8 Cap Toe - Black - 8.5 men men leather i leather X 2016-09- 12 2016-09- 12
SQL Server Please help answer question 5 Please type out the answer because I cannot read the last answer because the handwriting is not very clear. Thank you.
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…
Q4
Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.
Write an appropriate SQL query to display all the STUDENT_SURNAMES and STUDENT_NAMES, as well as the MODULE_NAMES that the student is registered for. Sort results according to student surname in ascending order.