Difference between revisions of "AdventureWorks hard questions"

From SQLZOO
Jump to: navigation, search
(Created page with "==AdventureWorks: hard questions== <div class='qu'> <p class='imper'>For every customer with a 'Main Office' in Dallas show AddressLine1 of the 'Main Office' and AddressLine1...")
 
Line 1: Line 1:
 +
{{AdventureWorks Assessment}}
 
==AdventureWorks: hard questions==
 
==AdventureWorks: hard questions==
  
Line 44: Line 45:
 
</source>
 
</source>
 
</div>
 
</div>
 +
{{AdventureWorks Assessment}}

Revision as of 20:01, 9 August 2012

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
 1000-9999
10000-

 

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

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense