ord_no 70001 70009 70002 70004 purch_amt 150.5 270.65 65.26 110.5 ord_date customer_id salesman_id 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 5002 5005 5001 5003 Given the Orders Table above: Write a SQL statement to find the highest purchase amount with their ID and order date, for those customers who have a higher purchase amount in a day is within the range 100 and 300.

Programming with Microsoft Visual Basic 2017
8th Edition
ISBN:9781337102124
Author:Diane Zak
Publisher:Diane Zak
Chapter12: Database Queries With Sql
Section: Chapter Questions
Problem 9RQ
icon
Related questions
Question
ord_no
70001
70009
70002
70004
purch_amt
150.5
270.65
65.26
110.5
ord_date customer_id salesman_id
2012-10-05
3005
2012-09-10 3001
2012-10-05
3002
2012-08-17 3009
5002
5005
5001
5003
Given the Orders Table above:
Write a SQL statement to find the highest purchase amount with their ID and order date, for those customers who have a higher purchase amount in a day is
within the range 100 and 300.
Transcribed Image Text:ord_no 70001 70009 70002 70004 purch_amt 150.5 270.65 65.26 110.5 ord_date customer_id salesman_id 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 5002 5005 5001 5003 Given the Orders Table above: Write a SQL statement to find the highest purchase amount with their ID and order date, for those customers who have a higher purchase amount in a day is within the range 100 and 300.
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Table
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
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr