PostgreSQL 풀이 | Unfinished Parts

문제 1.  Unfinished Parts

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.

Assumptions:
parts_assembly table contains all parts currently in production, each at varying stages of the assembly process.
An unfinished part is one that lacks a finish_date.
This question is straightforward, so let's approach it with simplicity in both thinking and solution.

https://datalemur.com/questions/tesla-unfinished-parts

Tesla SQL Interview Question | DataLemur

---

💡 문제 풀이 

`내 풀이`

소요 시간 02:29

SELECT part, assembly_step
FROM parts_assembly
WHERE finish_date IS NuLL;

 

`오답노트`

• 영어 해석하는데 시간이 더 오래걸리는 것 같다^_^

---

💯결과