This preview shows pages 1–2. 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: 6) How many were shipped to each of the two locations in each year and what was the average freight cost by year. Order by customer and year from newest to oldest. 7) What was the total cost of order number 10490? 8) List all suppliers (by name) that supply more than 3 products. Include the number of products and order the list in reverse alphabetical order by company name. 9) How much did Ernst Handel buy in Dollars in the first six months of 2008? 10) How much did each employee sell to them in the same time period? DELIVERABLE: DUE AT THE START OF CLASS ON THURSDAY, OCT. 8. Please turn in a hardcopy of 1) the SQL you used to answer each question, 2) a copy (partial if appropriate) of the results of your queries. (Worth 10% of Project 2)....
View Full Document
This note was uploaded on 03/21/2012 for the course MIS 235 taught by Professor Sunrro during the Spring '08 term at Miami University.
- Spring '08