Per the SQL standard, `column IN (subquery)` is equivalent to

**IN tests set membership:** is the column's value equal to at least one of the values in the set? That is exactly = ANY. `= ALL` would require equality to EVERY value (impossible unless the subquery is a single repeated value). `<` and `>` ANY/ALL test ordering, not membership.