A data analyst creates a report, and some of the fields are empty.

This question falls under theData Analysisdomain, focusing on SQL queries to identify data issues. The task is to find records with empty fields, which in SQL means NULL values.

WHERE [ColumnName] = NULL (Option A): In SQL, NULL cannot be compared using "="; this syntax is incorrect.

WHERE [ColumnName] IS NULL (Option B): This is the correct SQL syntax to identify NULL values, which represent empty fields.

WHERE [ColumnName] IS NOT NULL (Option C): This finds non-empty fields, the opposite of the requirement.

WHERE [ColumnName] = 'NULL' (Option D): This checks for the string "NULL," not a true NULL value, which is incorrect.

The DA0-002 Data Analysis domain includes "applying the appropriate descriptive statistical methods using SQL queries," such as identifying NULL values with IS NULL.