Part C(2 points)/* Bill of Materials -Recursive *//* The following code retrieves the components required for manufacturingthe "Mountain-500 Black, 48" (Product 992). Use it as the starter codefor calculating the material cost reduction if the component 815is manufactured internally at the level 1 instead of purchasing itfor use at the level 0.Use the list price of a component asthe material cost for the component. WITH Parts(AssemblyID, ComponentID, PerAssemblyQty, EndDate, ComponentLevel) AS
(
SELECT b. ProductAssemblyID, b.ComponentID, b.PerAssemblyQty,
b. EndDate,0 AS ComponentLevel
FROM Production. BillOfMaterials AS b
WHERE b. ProductAssemblyID =992 AND b. EndDate IS NULL

UNION ALL

SELECT bom. ProductAssemblyID, bom. ComponentID, p. PerAssemblyQty,
bom. EndDate, ComponentLevel +1
FROM Production. BillOfMaterials AS bom
INNER JOIN Parts AS p
ON bom. ProductAssemblyID =p. ComponentID AND bom. EndDate IS NULL
)
SELECT AssemblyID, ComponentID, Name, PerAssemblyQty, ComponentLevel
FROM Parts AS p
INNER JOIN Production. Product AS pr
ON p. ComponentID =pr. ProductID
ORDER BY ComponentLevel, AssemblyID, ComponentID;