write a query to get list name of employee who have registered 10 order.
Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter8: Advanced Data Handling Concepts
Section: Chapter Questions
Problem 17RQ
Related questions
Question
92.write a query to get list name of employee who have registered 10 order.
![Table Order
OrderQty CustomerID EmployeeID OrderDate ShipperiD
3 4/7/1996
5/7/1996
8/7/1996
8/7/1996
10
5
4
90
81
34
81
Table Employee
EmployeelD LastName
1 Davolio
2 Fuller
3 Leverling
1
2
FirstName
Nancy
Andrew
Janet
BirthDate
Photo
8/12/1968 EmpID1.pic
19/2/1952 EmpID2.pic
30/8/1963 EmpID3.pic
Notes
Education includes a BA....
Andrew received his BTS....
Janet has a BS degree..](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F403fe49d-ff62-4f94-b9fe-b1b3aa3d04f0%2Fd6b0a624-9b6b-47d5-a827-8bbcab003226%2Feqe158p_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Table Order
OrderQty CustomerID EmployeeID OrderDate ShipperiD
3 4/7/1996
5/7/1996
8/7/1996
8/7/1996
10
5
4
90
81
34
81
Table Employee
EmployeelD LastName
1 Davolio
2 Fuller
3 Leverling
1
2
FirstName
Nancy
Andrew
Janet
BirthDate
Photo
8/12/1968 EmpID1.pic
19/2/1952 EmpID2.pic
30/8/1963 EmpID3.pic
Notes
Education includes a BA....
Andrew received his BTS....
Janet has a BS degree..
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
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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
![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