{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

P1D0 - Preview Assignment - Northwinds SQL

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

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

MIS 235: Project 2 - Data Access & Business Decisions 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.

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

View Full Document
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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online