P1D0 - Preview Assignment - Northwinds SQL

P1D0 - Preview Assignment - Northwinds SQL - 6) How many...

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

View Full Document Right Arrow Icon
Preview Assignment - SQL and Northwinds The data associated with the data model is contained in tables with the owner MIS235. For example the customers table is MIS235.customers. 1) List order id, customer id, and freight for all orders that had a freight charge between $600 and $700 2) List order id, customer id, and shipped date for all orders shipped to postal code 5020 or 5022. Order the results by customer and date. 3) In total, how many orders were shipped to either location? 4) List the orders shipped to those two locations that were taken by employee #4. Include the order id, customer id, employee id, shipped date, city, and country in the listing. Order the results from most recent to earliest shipped. 5) Replace the ids in the same report with the company name and employee name.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

P1D0 - Preview Assignment - Northwinds SQL - 6) How many...

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