Complex Comparisons with SQL Subqueries and ANY Operator

SELECT
  product_name,
  price
FROM
  products
WHERE
  price > ANY (
    SELECT
      average_price
    FROM
      category_averages
    WHERE
      category_id = products.category_id
  );

How it works: This snippet uses the `ANY` operator with a correlated subquery to find products whose price is greater than *any* of the average prices within its own category. The inner subquery dynamically calculates average prices based on the outer query's `category_id`. `ANY` returns true if the price is greater than at least one of the values returned by the subquery, enabling flexible and powerful conditional filtering based on variable sets of values.