Parts with unfinished assembly
Parts with unfinished assembly
Tesla is analyzing bottlenecks in its production process. Find the parts whose assembly has already started but has not been completed yet. Return part and assembly_step.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| part | assembly_step |
|---|---|
| bumper | 3 |
| chassis | 2 |
| dashboard | 3 |
Tesla
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid