Southwind easy
From SQLZoo
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.'.