Back to questions
Tesla is investigating production bottlenecks and they need your help to extract the relevant data. Write a query to determine which parts have begun the assembly process but are not yet finished.
This question is straightforward, so let's approach it with simplicity in both thinking and solution.
Effective April 11th 2023, the problem statement and assumptions were updated to enhance clarity.
The bumpers in step 3 and 4 are the only item that remains unfinished as it lacks a recorded finish date.
The dataset you are querying against may have different input & output - this is just an example!
Great news! The parts table already includes all parts currently in production, so no additional filtering is necessary to exclude non-production parts.
To extract unfinished parts, we can simply filter for rows where the column contains no data, indicated by a NULL value. Read this tutorial to learn about handling NULL values using .