Subqueryis a query
that returns a result set of one column. The data type of the returned column
must be the same data type as the data type of scalar_expression. ORDER BY
clause, the COMPUTE clause, and the INTO keyword are not allowed in subquery).

Return type of ANY / SOME operator is boolean. It
returns TRUE when the comparison specified is TRUE for all pairs(scalar_expression, x)
where x is a value in the single-column set otherwise it returns FALSE.

Above query displays orders with a subtotal greater thanANYsaleamountin Sales_Totals_by_Amount table i.e.SubTotal greater than any amount
present in the
set returned by the subquery. That means that records selected by the outer
query should be greater than any of the values.

You
can achieve same result using min aggregate function in the subquery. To view this
example, please visit below link.