A Gentle Introduction to

SQL


Pick an engine:

Dressmaker Southwind database: easy questions

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

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

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

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

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