Unfinished Parts

Tesla is investingating bottlenecks in their production, and they need your help to extract the relevant data. Write a query that determines which parts have begun the assembly process but are not yet finished.

Assumptions:

·       Table parts_assembly contains all parts in production.

·       A part with no finish_date is an unfinished part.

table name: parts_assembly


Solution:

SELECT distinct part FROM parts_assembly
where finish_date is null;

Output:


SQL Script:

GO
CREATE TABLE [dbo].[parts_assembly](
       [part]
[nvarchar](50) NULL,
       [finish_date]
[datetime] NULL,
       [assembly_step]
[int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'battery', CAST(N'2022-01-22T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'battery', CAST(N'2022-02-22T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'battery', CAST(N'2022-03-22T00:00:00.000' AS DateTime), 3)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'bumper', CAST(N'2022-01-22T00:00:00.000' AS DateTime), 1)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'bumper', CAST(N'2022-02-22T00:00:00.000' AS DateTime), 2)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'bumper', NULL, 3)
GO
INSERT [dbo].[parts_assembly] ([part], [finish_date], [assembly_step]) VALUES (N'bumper', NULL, 4)
GO


Comments (0)
Questions List