What are the total per assembly quantity for unit measure code EA, IN and OZ respectively? What are the name of these 3 code?
Pre assembly quantity refers to PerAssemblyQty
SELECT SUM(T1.PerAssemblyQty), T2.Name FROM BillOfMaterials AS T1 INNER JOIN UnitMeasure AS T2 ON T1.UnitMeasureCode = T2.UnitMeasureCode WHERE T1.UnitMeasureCode IN ('EA', 'IN', 'OZ') GROUP BY T2.Name