A Gentle Introduction to

SQL


Pick an engine:

Southwind database: easy questions

1 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

2 For each product show the total number ordered. Include just the product code and the number ordered

3 Give the firm and the address of each company that placed an order on 12th February 2002

4 Give all details of the order made by customer 'Assiduous Assoc.' on 12th February 2002. Include the product code, the description the price and the number ordered

5 Find the total number of 'Wilmington' ordered by 'Contiguous Corp.