Difference between revisions of "AdventureWorks easy questions"

From SQLZOO
Jump to: navigation, search
(Created page with "<div class='qu'> <p class='imper'>Show the first name and the email address of customer with CompanyName 'Bike World'</p> <source lang='sql' class='def'> </source> </div> <di...")
 
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{AdventureWorks Assessment}}
 +
Five easy questions. Most of these require you to use only one or two tables.
 +
You will get at most 11 points for each of the questions from this section.
 +
 +
 +
 +
 +
 +
 
<div class='qu'>
 
<div class='qu'>
 
<p class='imper'>Show the first name and the email address of customer with CompanyName 'Bike World'</p>
 
<p class='imper'>Show the first name and the email address of customer with CompanyName 'Bike World'</p>
Line 30: Line 39:
 
</source>
 
</source>
 
</div>
 
</div>
 +
{{AdventureWorks Assessment}}

Latest revision as of 06:25, 14 August 2012

Five easy questions. Most of these require you to use only one or two tables. You will get at most 11 points for each of the questions from this section.




Show the first name and the email address of customer with CompanyName 'Bike World'

 

Show the CompanyName for all customers with an address in City 'Dallas'.

 

How many items with ListPrice more than $1000 have been sold?

 

Give the CompanyName of those customers with orders over $100000. Include the subtotal plus tax plus freight.

 

Find the number of left racing socks ('Racing Socks, L') ordered by CompanyName 'Riding Cycles'

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense