assembly_jobs(job_id, started_at, completed_at, scrapped_at)

Return the job_id of every job that has started but is neither completed nor scrapped. Both of those timestamps are NULL.

Comparing to NULL with = or != never matches. NULL needs IS NULL.

Tables

assembly_jobs

job_id  started_at           completed_at         scrapped_at
------  -------------------  -------------------  -------------------
1       2026-04-01 08:00:00  NULL                 NULL
2       2026-04-01 09:00:00  2026-04-02 09:00:00  NULL
3       2026-04-01 10:00:00  NULL                 2026-04-01 18:00:00
4       NULL                 NULL                 NULL
5       2026-04-03 07:00:00  NULL                 NULL

Expected result

job_id
------
1
5