Find Records With Missing Timestamps | Dataford Interview Questions

The Apex Systems QA test run dashboard stores each automated test execution in a single log table. Some records were created without an execution timestamp and must be identified for data-quality review.

Write a PostgreSQL query to return test execution records where executed_at is missing.

Requirements

Return the execution ID, test name, environment, and execution timestamp.
Include only rows where executed_at is NULL, ordered by execution ID ascending.

Schema

qa_test_runs

Column	Type	Description
execution_idPK	INTEGER	Unique test execution identifier
test_name	VARCHAR(150)	Name of the QA test
environment	VARCHAR(30)	Execution environment
executed_at	TIMESTAMPTZ	Test execution start time, which may be missing
status	VARCHAR(20)	Test result status

Your question is Find Records With Missing Timestamps. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a PostgreSQL query to return test execution records where executed_at is missing.

Requirements

Return the execution ID, test name, environment, and execution timestamp.
Include only rows where executed_at is NULL, ordered by execution ID ascending.

Schema

qa_test_runs

Column	Type	Description
execution_idPK	INTEGER	Unique test execution identifier
test_name	VARCHAR(150)	Name of the QA test
environment	VARCHAR(30)	Execution environment
executed_at	TIMESTAMPTZ	Test execution start time, which may be missing
status	VARCHAR(20)	Test result status

Your question is Find Records With Missing Timestamps. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.