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).

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

How many shipments has each shipper made at charges greater than average?

Which suppliers do not sell dairy products?