AdventureWorks easy questions

From SQLZOO
Revision as of 20:00, 9 August 2012 by Andr3w (Talk | contribs)

Jump to: navigation, search

AdventureWorks: easy questions

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