SUBQUERIES

Exercises

Create a list of customers located in the same city as a supplier, showing company name, city, and country (try with a subquery and check with a join).    (14 rows)

Find all freight charges that are greater than average and list along with the shipper's name (find the average first, as a check).  (242 rows)

How many shipments has each shipper made at charges greater than average?  (3 rows, 2 or 3 columns)

Which suppliers do not sell dairy products?  (25 rows)