If the inner query returns multiple values then operators like > and < can’t be used
In that case we can use “operator ANY”, “operator ALL” and IN()
>ANY : The value should be greater than any one of the value
>ALL : The value should be greater than all the values
=ANY : Same as IN() operator