Unfinished Parts
Find all parts that have begun the assembly process but are not yet finished. A part is unfinished if it has a NULL finish_date. Output part and assembly_step.
1 SQL practice question in our Tesla collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy
Independent practice resource. Not affiliated with or endorsed by Tesla.
These topics come from the questions in this set. Pick one to open the matching problems.
Find all parts that have begun the assembly process but are not yet finished. A part is unfinished if it has a NULL finish_date. Output part and assembly_step.
1 Tesla problem, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
part (VARCHAR) · finish_date (DATE) · assembly_step (INTEGER)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Tesla SQL free188 SQL practice questions. 23 companies. Free access to every problem.