Difference between revisions of "AdventureWorks medium questions"

From SQLZOO
Jump to: navigation, search
(Created page with "==AdventureWorks: medium questions== <div class='qu'> <p class='imper'>A "Single Item Order" is a customer order where only one item is ordered. Show the SalesOrderID and the...")
 
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==AdventureWorks: medium questions==
+
{{AdventureWorks Assessment}}
  
 +
 +
 +
 +
 +
 +
==AdventureWorks: medium questions==
 +
<span id=startAt class=params>6</span>
 
<div class='qu'>
 
<div class='qu'>
 
<p class='imper'>A "Single Item Order" is a customer order where only one item is ordered.
 
<p class='imper'>A "Single Item Order" is a customer order where only one item is ordered.
Line 33: Line 40:
 
</source>
 
</source>
 
</div>
 
</div>
 +
{{AdventureWorks Assessment}}

Latest revision as of 06:26, 14 August 2012




[edit] AdventureWorks: medium questions

6

A "Single Item Order" is a customer order where only one item is ordered. Show the SalesOrderID and the UnitPrice for every Single Item Order.

 

Where did the racing socks go? List the product name and the CompanyName for all Customers who ordered ProductModel 'Racing Socks'.

 

Show the product description for culture 'fr' for product with ProductID 736.

 

Use the SubTotal value in SaleOrderHeader to list orders from the largest to the smallest. For each order show the CompanyName and the SubTotal and the total weight of the order.

 

How many products in ProductCategory 'Cranksets' have been sold to an address in 'London'?

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense