Missing Sequence Detection

How can we detect orders with missing transaction dates?

Advanced⏱ 3 Minutes⭐ 1860 XP

🤔 THE QUESTION

How can we detect orders with missing transaction dates?

💡 WHAT IS IT?

Querying for IS NULL on timestamp fields identifies broken pipeline sequences or dropped timestamps.

🎯 WHAT IS IT USED FOR?

Ingestion data anomaly checks, corruption detection in event streams, audit logging.

💻 EXAMPLE

SELECT
customer_id,
order_date
FROM orders
WHERE order_date IS NULL;

Practice typing production-grade SQL code for Missing Sequence Detection.