PostgreSQL

PostgreSQL ANY

Compare a value with at least one value returned by a subquery.

Use ANY

SELECT * FROM products
WHERE year > ANY (
  SELECT year FROM featured_products
);

The condition is true when the comparison succeeds for one or more subquery results. SOME is an equivalent keyword.