Your question is Find Records With Missing Timestamps. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
executed_at is NULL, ordered by execution ID ascending.| 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 |