Difference between revisions of "AdventureWorks hard questions"
From SQLZOO
(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
Hard questions: 11..15
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.
Hard questions: 11..15
