ISKier the SALEMAD NAME MUMERIC (8) WICHAR) wCHAR (16 DECMALD aSTOMERD MERC(S) CUT NAE CHR ( CITY OHAR(1S MUMERIC (3) SALEMAN D MMERC (S) CITY COMMISSION GRADE orders YORD NO PURCH AMT NUMERIC (S) DECIMAL ( DATE ORD DATE CUSTOMER JD NUMERIC (5) SALESMAN O NUMERIC (6) Find the highest purchase amount with customer ID of the one who made it, along with the order date; for those customers who have a higher purchase amount in a day within the range 2000 and 6000.
ISKier the SALEMAD NAME MUMERIC (8) WICHAR) wCHAR (16 DECMALD aSTOMERD MERC(S) CUT NAE CHR ( CITY OHAR(1S MUMERIC (3) SALEMAN D MMERC (S) CITY COMMISSION GRADE orders YORD NO PURCH AMT NUMERIC (S) DECIMAL ( DATE ORD DATE CUSTOMER JD NUMERIC (5) SALESMAN O NUMERIC (6) Find the highest purchase amount with customer ID of the one who made it, along with the order date; for those customers who have a higher purchase amount in a day within the range 2000 and 6000.
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
Related questions
Question
![Consider the following structure of an 'inventory Oracle database.
cuelomer
***
MUMERIC ($)
VARCHAR 30)
VARCHAR (15
DECIMAL)
SALESMANJD
NAME
CUSTOMER JD ERC ($)
CUST NAME RCHAR (30
CHAR (15
MUMERIC (3)
CITY
CITY
COMMISSION
GRADE
SALESMAN ID NUMERIC ($)
orders
ORD NO
NUMERIC (5)
PURCH AMT
DECIMAL (8,2)
ORD DATE
DATE
CUSTOMER ID NUMERIC (5)
SALESMAN ID NUMERIC (5)
Find the highest purchase amount with customer ID of the one who made it, along with the order date; for those customers who have
a higher purchase amount in a day within the range 2000 and 6000.
Use the editor to format your answer
81](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fdc74b2be-c95b-4292-b113-044b2efa725e%2F605b1153-a85a-4ffe-91c3-864fa239d264%2Fl7t461n_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Consider the following structure of an 'inventory Oracle database.
cuelomer
***
MUMERIC ($)
VARCHAR 30)
VARCHAR (15
DECIMAL)
SALESMANJD
NAME
CUSTOMER JD ERC ($)
CUST NAME RCHAR (30
CHAR (15
MUMERIC (3)
CITY
CITY
COMMISSION
GRADE
SALESMAN ID NUMERIC ($)
orders
ORD NO
NUMERIC (5)
PURCH AMT
DECIMAL (8,2)
ORD DATE
DATE
CUSTOMER ID NUMERIC (5)
SALESMAN ID NUMERIC (5)
Find the highest purchase amount with customer ID of the one who made it, along with the order date; for those customers who have
a higher purchase amount in a day within the range 2000 and 6000.
Use the editor to format your answer
81
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning