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
Get step-by-step solutions from verified subject matter experts
