(written in sql)

/* 27. Create a list of customers (companyname) and some information about each order (orderid, orderdate, shipdate) they have placed. (830 Records) */

/* 28. Create list of products that were shipped to customers on 04/18/2012. (4 Records) */

/* 29. Create a list of customers that have ordered Tofu. Make sure to list each customer only once. (18 Records) */

/* 31. Create a mailing list to send information to all the customers, employees, and suppliers. Sort the list by city. (129 records) */

/* 32. Create a view called NumCustomerOrders which lists all the customers and the number of orders they have placed. Be sure to list the customer even if they have not placed an order. (91 records) */

Suppliers * SupplierID CompanyName Contact Name ContactTitle Address City Region PostalCode Country Phone Fax HomePage Products Y ProductID Product Name SupplierID CategoryID QuantityPerUnit Unit Price UnitsInStock Units OnOrder ReorderLevel Discontinued Order_Details y OrderID 7 ProductID Unit Price Quantity Discount Orders OrderID CustomerID EmployeeID OrderDate Required Date ShippedDate Ship Via Freight ShipName ShipAddress Ship City Ship Region ShipPostalCode Ship Country Customers y CustomerID CompanyName Contact Name Contact Title Address City Region PostalCode Country Phone Fax Categories 7 CategoryID CategoryName Description Picture Shippers ShipperID CompanyName Phone Employees 7 EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country Home Phone Extension Photo Notes ReportsTo