This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Mike Mesrobian, Zach Adams, Xuetong Zhou, Daniel Dever, Kelsey Fish Group #1 Project #3 Section P Day 1 3/25/2010 Sent: 3/25/10 1:45:00 PM To: vanzandtj@Northwinds.biz CC: BCC: Subject: Information on Additional Questions Mr. Van Zandt, Many suppliers from foreign countries have no information under the region category of the database. The company spreads out its supply chain and is not overly reliant on any supplier. The two largest suppliers, with five products each, are Plusspar Lebensmittelgromrkte AG and Pavlova, Ltd. The three highest orders are significantly higher than the next ten and have all occurred since November 2009. The companies with the five highest purchase amounts, with totals included, are QUICK-Stop ($17250), Save-a-lot Markets ($163231.90), Hanari Carnes ($15810), Queen Cozinha ($12281.20), and Mere Paillarde ($11490.70). Best of luck, Data and Decision-Making Support SELECT * FROM mis235.Suppliers WHERE Region = 'Null' ORDER BY CompanyName (20 Rows)...
View Full Document
This document was uploaded on 11/02/2011 for the course MIS 235 at Miami University.
- Spring '08