Write a SELECT statement that returns the OrderID and OrderDate along with the CustomerID, contact (customer last name, first) and Phone of the customer who placed the order if the order has not yet been at least partially shipped.  An order is at least partially shipped if the status of any part ordered on the order is SHIPPED.

Answer rating: 100% (QA)

You can use a SQL query with a JOIN and a WHERE clause to retrieve the desired information Youll nee... View the full answer