Southwind hard

From SQLZOO
Revision as of 14:45, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Southwind database: hard questions

Produce an exceptions list. There are three kinds of exception:

  • RETURN - a customer returns a product
  • INCOMPLETE - a customer is sent an incomplete shipment
  • OUTSTANDING - an order has not been shipped

The exceptions list should show the customer/supplier id and name, the date, the exception code, the product involved and any other details that are available - such as the explanation

 

For each item, calculate the total number currently in stock based on the most recent stock check and deliveries/shipments since that date. You should assume that customer returned items are put back in stock

 

Identify the best selling product line for each month. The best selling product is the one with the greatest value of orders.

 

Produce a bar chart showing the total capital value of the stock week by week for the 8 weeks from 11th January to 1st March 2007. The bar chart may have horizontal bars made of characters

 

Obtain a list of discrepancies in the stock levels

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense