How would you determine which orders have not yet been shipped to the customer?

Figure 1-5:

ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS Customer# Lastname Firstname Email Address City State Zip Referred Region BOOKAUTHOR AUTHOR BOOKS AuthorID ISBN ISBN AuthorID Lname ORDERITEMS Title Pubdate PubID Fname Order# Item# Cost Retail ISBN Quantity Paideach Discount PUBLISHER Category PubID Name PROMOTION Contact Phone Gift Minretail Maxretail