Practice Interview Questions
| Question | Status |
|---|---|
Write a query to find all the parts that have been initiated for assembly but remain unfinished.
parts_assembly table:
| Column Name | Description |
|---|---|
| part | Name or identifier of the part |
| finish_date | Date the assembly was completed |
| assembly_step | Step number in the assembly process |
| part |
|---|
| bumper |
| windshield |
Write a query to find all the parts that have been initiated for assembly but remain unfinished.
parts_assembly table:
| Column Name | Description |
|---|---|
| part | Name or identifier of the part |
| finish_date | Date the assembly was completed |
| assembly_step | Step number in the assembly process |
| part |
|---|
| bumper |
| windshield |