business memo w answers for exercise 2

business memo w answers for exercise 2 - TO Professor...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
TO: Professor Lancaster, Architect of the Miami Oracle Cyber-World FROM: Ryan Hayes, Cyber-Miner, Digging Up Very Useful Information Subject: Northwinds Database The mission of this project is two things: to know more about Northwinds’ products and better understand where they are being shipped. We have discovered that the Camembert Pierrot sells the highest quantity of goods with a number of 1577. To get this answer you must use the SQL Code: SELECT ProductName, SUM(Quantity) FROM MIS235.Products, MIS235.OrderDetails WHERE MIS235.Products.ProductID=MIS235.OrderDetails.ProductID GROUP BY ProductName ORDER BY SUM(Quantity) DESC Next, to find which product Northwinds has sold the most in revenue, I found that Cote de Blaye was on top with $13,522,029.50. To find this you use the SQL Code: SELECT ProductName, to_char(SUM(MIS235.Products.UnitPrice*MIS235.OrderDetails.Quantity), '$9,999,999,999.99') as Revenue FROM MIS235.Products, MIS235.OrderDetails GROUP BY ProductName ORDER BY to_char(SUM(MIS235.Products.UnitPrice*MIS235.OrderDetails.Quantity),
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/01/2011 for the course MIS 235 at Miami University.

Page1 / 2

business memo w answers for exercise 2 - TO Professor...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online