Southwind hard
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