DISTINCT is used to return unique values in SELECT clause and has nothing to do with sub-queries.
IN operator can be used both with sub-queries and with manually specified values.
ANY and ALL operators should be used with sub-queries only.