Dressmaker easy

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

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

Dressmaker database: easy questions

List the post code, order number, order date and garment descriptions for all items associated with Ms Brown.

 

List the customer name, postal information, order date and order number of all orders that have been completed.

 

Which garments have been made or are being made from 'red abstract' or 'blue abstract' coloured materials.

 

How many garments has each dressmaker constructed? You should give the number of garments and the name and postal information of each dressmaker.

 

Give the names of those dressmakers who have finished items made from silk for completed orders.

 
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense