Difference between revisions of "AdventureWorks resit questions"

From SQLZOO
Jump to: navigation, search
(Created page with "==AdventureWorks: resit questions== <div class='qu'> <p class='imper'>List the SalesOrderNumber for the customer 'Good Toys' 'Bike World'</p> <source lang='sql' class='def'> ...")
 
Line 1: Line 1:
 +
{{AdventureWorks Assessment}}
 
==AdventureWorks: resit questions==
 
==AdventureWorks: resit questions==
  
Line 35: Line 36:
 
</source>
 
</source>
 
</div>
 
</div>
 +
{{AdventureWorks Assessment}}

Revision as of 20:01, 9 August 2012

AdventureWorks: resit questions

List the SalesOrderNumber for the customer 'Good Toys' 'Bike World'

 

List the ProductName and the quantity of what was ordered by 'Futuristic Bikes'

 

List the name and addresses of companies containing the word 'Bike' (upper or lower case) and companies containing 'cycle' (upper or lower case). Ensure that the 'bike's are listed before the 'cycles's.

 

Show the total order value for each CountryRegion. List by value with the highest first.

 

Find the best customer in each region.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense