Objective

Write a SQL query to identify parts that have started assembly but do not have a finish date.

Table Schema:

• parts_assembly

Task Requirements:

• Identify parts that have started assembly but have no finish date (finish_date is NULL)
• Return the part name and assembly step for unfinished parts
• No specific sorting required
  
  

Output columns: assembly_step, part

SELECT 
    part,
    assembly_step
FROM parts_assembly
WHERE finish_date IS NULL;

Explanation

Step 1: Filter for Unfinished Parts

Apply WHERE finish_date IS NULL to retrieve only assembly records where the finish date has not been recorded, indicating the step is incomplete.

WHERE finish_date IS NULL

Step 2: Select Required Columns

Return part and assembly_step to identify which parts are incomplete and at which step.

SELECT part, assembly_step