Southwind easy

From SQLZOO
Revision as of 15:42, 19 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Southwind database: easy questions

List all the products ordered by customer c006. Include the description of the product, the date that the order was received and the number ordered.

 

For each product show the total number ordered. Include just the product code and the number ordered

 

Give the firm and the address of each company that placed an order on 12th February 2007.

 

Give all details of the order made by customer 'Assiduous Assoc.' on 12th February 2007. Include the product code, the description the price and the number ordered.

 

Find the total number of 'Wilmington' ordered by 'Contiguous Corp.'.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense