Last updated Unknown

Use a subquery in each of these.

1. Find the products with a price lower than the average price of all products.

2. Find the names of customers who have placed at least one order.

3. Find the names of products that belong to the ‘Beverages’ category (do NOT use any JOINs).

   • HINT: Remember you can use WHEREs in you subqueries!

4. List the names of products supplied by a supplier named ‘Exotic Liquids’ (do NOT use any JOINs).

5. Find the name, city and address of customers who live in the same city as any of the suppliers.