BIOL 1001 Chapter : Biol Ch 10 Part 3
Document Summary
Project description: the hints from mrs. joni are highlighted in yellow. Northwind traders, an international gourmet food distributor, is concerned about shipping delays over the last six months. Review the orders over the past six months and identify any order that was not shipped within 30 days. Each customer that falls within that time frame will be called to inquire about any problems the delay may have caused. In addition, you will create an order summary and an order summary by country. You have created a smaller version of the database, which you will use for testing purposes. For the purpose of grading the project you are required to perform the following tasks: Companyname, contactname, contacttitle, and phone (in that order). From the orders table, include the fields orderid, orderdate, and shippeddate (in that order). Run the query and then examine the records.
