Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).

Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).

New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter12: Working With Document Nodes And Style Sheets: Creating A Dynamic Document Outline
Section: Chapter Questions
Problem 2CP4
See similar textbooks
icon
Related questions
Question

Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd quarter of 2017 (April to June 2017).

department line product brand DEPT_NUM DECIMAL(5,0) INV_NUM DECIMAL(38,0) * PROD_SKU VARCHAR(15) BRAND ID DECIMAL (4,0) DEPT NAME VARCHAR(50) O DEPT_MAIL_BOX VARCHAR(3) O DEPT PHONE VARCHAR(9) * LINE_NUM DECIMAL(10,0) PROD_DESCRIPT VARCHAR(255) BRAND_NAME VARGCHAR(100) O PROD_SKU VARCHAR(15) + O PROD TYPE VARCHAR (255) O BRAND TYPE VARCHAR(20) O LINE_QTY DECIMAL (10,0) PROD_BASE VARCHAR(255) Indexes EMP_NUM DECIMAL(6,0) OLINE_PRICE DECIMAL(8,2) +O PROD_CATEGORY VARCHAR(255) Indexes Indexes O PROD_PRICE DECIMAL(10,2) O PROD_QOH DECIMAL(10,0) O PROD_MIN DECIMAL(10,0) O BRAND ID DECIMAL (4,0) O vendor employee D invoice Indexes VEND_ID DECIMAL(6,0) INV_NUM DECIMAL (38,0) INV DATE DATE O CUST CODE DECIMAL (38,0) EMP_NUM DECIMAL(6,0) VEND_NAME VARCHAR(255) EMP_FNAME VARCHAR(20) OVEND STREET V ARCHAR(50) %23 VEND CITY VARCHAR(50) EMP_LNAME VARCHAR(25) O EMP EMAIL VARCHAR(25) EMP_PHONE VARCHAR(20) H- O INV_TOTAL DECIMAL(11,2) OVEND_STATE VARCHAR(2) O EMPLOYEE_ID DECIMAL (6,0) O VEND ZIP VARCHAR(5) I supplies PROD_SKU VARCHAR(15) VEND_ID DECIMAL(6,0) EMP HIREDATE DATE Indexes Indexes O EMP TITLE VARCHAR (45) O EMP_COMM DECIMAL (2,2) O DEPT NUM DECIMAL(5,0) Indexes Indexes customer * CUST_CODE DECIMAL (38,0) O CUST_FNAME VARCHAR(20) O CUST_LNAME VARCHAR(20) O CUST_STREET VARCHAR(70) O CUST_CITY VARCHAR(50) O CUST STATE CHAR(2) O CUST_ZIP CHAR(5) |salary_history EMP_NUM DECIMAL(6,0) P SAL_FROM DATE SAL_END DATE O SAL_AMOUNT DECIMAL(10,2) Indexes O CUST BALANCE DECIMAL (8,2) Indexes
Transcribed Image Text:department line product brand DEPT_NUM DECIMAL(5,0) INV_NUM DECIMAL(38,0) * PROD_SKU VARCHAR(15) BRAND ID DECIMAL (4,0) DEPT NAME VARCHAR(50) O DEPT_MAIL_BOX VARCHAR(3) O DEPT PHONE VARCHAR(9) * LINE_NUM DECIMAL(10,0) PROD_DESCRIPT VARCHAR(255) BRAND_NAME VARGCHAR(100) O PROD_SKU VARCHAR(15) + O PROD TYPE VARCHAR (255) O BRAND TYPE VARCHAR(20) O LINE_QTY DECIMAL (10,0) PROD_BASE VARCHAR(255) Indexes EMP_NUM DECIMAL(6,0) OLINE_PRICE DECIMAL(8,2) +O PROD_CATEGORY VARCHAR(255) Indexes Indexes O PROD_PRICE DECIMAL(10,2) O PROD_QOH DECIMAL(10,0) O PROD_MIN DECIMAL(10,0) O BRAND ID DECIMAL (4,0) O vendor employee D invoice Indexes VEND_ID DECIMAL(6,0) INV_NUM DECIMAL (38,0) INV DATE DATE O CUST CODE DECIMAL (38,0) EMP_NUM DECIMAL(6,0) VEND_NAME VARCHAR(255) EMP_FNAME VARCHAR(20) OVEND STREET V ARCHAR(50) %23 VEND CITY VARCHAR(50) EMP_LNAME VARCHAR(25) O EMP EMAIL VARCHAR(25) EMP_PHONE VARCHAR(20) H- O INV_TOTAL DECIMAL(11,2) OVEND_STATE VARCHAR(2) O EMPLOYEE_ID DECIMAL (6,0) O VEND ZIP VARCHAR(5) I supplies PROD_SKU VARCHAR(15) VEND_ID DECIMAL(6,0) EMP HIREDATE DATE Indexes Indexes O EMP TITLE VARCHAR (45) O EMP_COMM DECIMAL (2,2) O DEPT NUM DECIMAL(5,0) Indexes Indexes customer * CUST_CODE DECIMAL (38,0) O CUST_FNAME VARCHAR(20) O CUST_LNAME VARCHAR(20) O CUST_STREET VARCHAR(70) O CUST_CITY VARCHAR(50) O CUST STATE CHAR(2) O CUST_ZIP CHAR(5) |salary_history EMP_NUM DECIMAL(6,0) P SAL_FROM DATE SAL_END DATE O SAL_AMOUNT DECIMAL(10,2) Indexes O CUST BALANCE DECIMAL (8,2) Indexes
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Basic sql queries
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
SEE MORE TEXTBOOKS