Explain anti-joins in SQL

Question Explain

This tests knowledge of finding non-matching records. It is a specific pattern for data exclusion.