Be Careful When Using “NOT IN” in SQL

+ 3 simple solutions to make sure you’re not caught out

Recently, I came across Benjamin Thürer’s excellent article:

How to Avoid Five Common Mistakes in Google BigQuery / SQL

…in which he cautions us about using the NOT IN SQL clause in BigQuery.