Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3RA
Related questions
Question
I want SQL statement.
The picture has names of table and column.
Find customers who have more than one order:
Show customer number and customer name in your result. Sort the result according to customer number. (Do not show duplicate values)
Do not use aggregate functions (COUNT()) to answer this question.
Hint: To find customers with different order numbers, you need to join the table dbs211_orders with itself. (If for the same customer, there are different orders.) To get the given result, you may need to join more tables.
![DBS211_CUSTOMERS
CUSTOMERNUMBER
CUSTOMERNAME
CONTACTLASTNAME
CONTACTFIRSTNAME
PHONE
ADDRESSLINE 1
ADDRESSLINE2
CITY
STATE
POSTAL CODE
COUNTRY
SALESREPEMPLOYEENUMBER
CREDITLIMIT
DBS211 EMPLOYEES
DBS211_OFFICES
DBS211_ORDERDETAILS
ORDERNUMBER
PRODUCTCODE
QUANTITY ORDERED
PRICEEACH
ORDERLINENUMBER
DBS211_ORDERS
ORDERNUMBER
ORDERDATE
REQUIREDDATE
SHIPPEDDATE
STATUS
COMMENTS
CUSTOMERNUMBER
DBS211_PAYMENTS
DBS211_PRODUCTLINES
DBS211_PRODUCTS](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F33182b36-0ae9-4d27-a72b-3861bbb0e77d%2F4830553d-ceb8-4b23-8216-9902331d5208%2F91tlbh7_processed.jpeg&w=3840&q=75)
Transcribed Image Text:DBS211_CUSTOMERS
CUSTOMERNUMBER
CUSTOMERNAME
CONTACTLASTNAME
CONTACTFIRSTNAME
PHONE
ADDRESSLINE 1
ADDRESSLINE2
CITY
STATE
POSTAL CODE
COUNTRY
SALESREPEMPLOYEENUMBER
CREDITLIMIT
DBS211 EMPLOYEES
DBS211_OFFICES
DBS211_ORDERDETAILS
ORDERNUMBER
PRODUCTCODE
QUANTITY ORDERED
PRICEEACH
ORDERLINENUMBER
DBS211_ORDERS
ORDERNUMBER
ORDERDATE
REQUIREDDATE
SHIPPEDDATE
STATUS
COMMENTS
CUSTOMERNUMBER
DBS211_PAYMENTS
DBS211_PRODUCTLINES
DBS211_PRODUCTS
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 with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Follow-up Questions
Read through expert solutions to related follow-up questions below.
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Fundamentals of Information Systems](https://www.bartleby.com/isbn_cover_images/9781305082168/9781305082168_smallCoverImage.gif)
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning