Quick
Ref.
Functions
- date
- number
- string
Data Types
- date
- number
- string
| Dressmaker Southwind database: easy questions
1.
List the post code, order number, order date and garment
descriptions for all items associated with Ms Brown.
|
Results
|
2.
List the customer name, postal information, order date and order
number of all orders that have been completed.
|
Results
|
3.
Which garments have been made or are being made from 'red abstract'
or 'blue abstract' coloured materials.
|
Results
|
4.
How many garments has each dressmaker constructed? You should give
the number of garments and the name and postal information of each
dressmaker.
|
Results
|
5.
Give the names of those dressmakers who have finished items made
from silk for completed orders.
|
Results
|
| |
