The Question
SQLIdentifying Incomplete Assembly Parts
Tesla's manufacturing system tracks individual assembly steps for various car parts. A part is considered 'in-progress' if it appears in the assembly log but has at least one step where the completion timestamp is missing. Write a query to return a unique list of all parts that are currently unfinished.
PostgreSQL
DISTINCT
Filter on NULL
March 31, 2026