SQL Assigment

For all the items below, what is required is the SQL to retrieve the answer. Please send you submissions by 4/12/08.

Connection details will be provided in the class. You can use whatever database client you want to use. A list of some free ones is provided in a different posting on this site.

1. Display all the products sorted in alphabetical order.

2. Display all the products sorted by unit price in descending order.

3. Find the most expensive product (i.e. the product with the highest unit price).

4. Get the name of the sales representative that worked on the most expensive order

5. Obtain a list of orders handled by Andrew Fuller

6. Get a list of products with the lowest unit price

7. List all employees that service the Western region.

8. List all the suppliers for products sold as part of Order 10252

9. List all customers that have made placed more than 3 orders.