AGGREGATE FUNCTIONS

Exercises

(Note: None of these exercises require more than one table.)

How many different products are represented in the database?

How many products in each category?

Find the average freight charged by each shipper.

Modify the first query: Average freight by shipper for freight above $75

Modify the first query: Average freight by shipper showing only averages above $75

Find the most popular product (as measured by how many ordered)

Find the most expensive product

Practical example (contrived in this database):

Find duplicate (or more) product listings in Order Details.

Find duplicate (or more) product-price pairings (same product and price) in Order Details

(Compare with Find Duplicates wizard in each case)