AdventureWorks hard questions

Revision as of 20:26, 9 August 2012 by Andr3w (Talk | contribs)

Jump to: navigation, search

AdventureWorks: hard questions


For every customer with a 'Main Office' 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.


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


Show the best selling item by value.


Show how many orders are in the following ranges (in $):

    RANGE      Num Orders      Total Value
    0-  99
  100- 999


Identify the three most important cities. Show the break down of top level product category against city.