Difference between revisions of "AdventureWorks medium questions"

From SQLZOO
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{AdventureWorks Assessment}}
 
{{AdventureWorks Assessment}}
==AdventureWorks: medium questions==
 
  
 +
 +
 +
 +
 +
 +
==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.

Latest revision as of 07: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