The NOT EXISTS keyword will be true if:

• any row in the subquery meets the condition.
• all rows in the subquery fail the condition.
• both of these two conditions are met.
• neither of these two conditions is met.