Missing Data Count

How can we count how many records have missing data?

Advanced⏱ 3 Minutes⭐ 1350 XP

🤔 THE QUESTION

How can we count how many records have missing data?

💡 WHAT IS IT?

Combining COUNT(*) with a WHERE ... IS NULL condition audits missing data volume.

🎯 WHAT IS IT USED FOR?

Data quality audits, completeness SLAs, identifying ingestion pipeline drops.

💻 EXAMPLE

SELECT
COUNT(*) AS missing_manager_count
FROM employees
WHERE manager_id IS NULL;

Practice typing production-grade SQL code for Missing Data Count.