Question
Select the OrderID and the Customer Name from the Orders table that was sold by the employee with the last name of Peacock...table Orders contains
Select the OrderID and the Customer Name from the Orders table that was sold by the employee with the last name of Peacock...table Orders contains categories OrderID CustomerID EmployeeID OrderDate ShipperID table Customers contains CustomerID CustomerName ContactName Address City PostalCode Country table Employees contains EmployeeID LastName FirstName BirthDate Photo Notes, so table Orders has the category EmployeeID and the table Employees contains EmployeeID and also the Employee's last name. The table Orders also contains CustomerID as well as the table Customers which contains the information of the EmployeeID of the employee that sold the order.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started