11.
For every customer in Dallas show AddressLine1 of the 'Main Office' and AddressLine1 of the 'Shipping' address - if there is no shipping address leave it blank. Use one row per customer.
Results
12.
For each order show the SalesOrderID and SubTotal calculated three ways:
A) From the SalesOrderHeader
B) Sum of OrderQty*UnitPrice
C) Sum of OrderQty*ListPrice
Results
13.
Show the best selling item by value.
Results
14.
Show how many orders are in the following ranges (in $):
RANGE Num Orders Total Value
0- 99
100- 999
1000-9999
10000-
Results
15.
Identify the three most important cities.
Show the break down of top level product
category against city.
