Dressmaker easy

From SQLZoo
Jump to navigation Jump to 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.