Question: The data type of LastName , FirstName , and Notes is string. The data type of OrderID , ProductID , UnitPrice , Quantity , CustomerID

The data type of LastName,FirstName, and Notes is string.
The data type of OrderID,ProductID,UnitPrice,Quantity,CustomerID,EmployeeID,and ShipperID is number.
The data type of BirthDate and OrderDate is date.
EmployeeID in relation Orders represents the single employee who handles this order, and it is a foreign key that references EmployeeID in relation Employees.
Each order contains only a single type of product with a positive quantity.
Question: Find all orders where the shipper ID of the order is greater than or equal to 1000. Return order ID, order date, first name and last name of the employee who handles the order, arranged in descending order of order date.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!