What proportion of work order is in Subassembly?
proportion = DIVIDE(SUM(Name = 'Subassembly'). (COUNT(WorkOrderID)));
SELECT 100.0 * SUM(CASE WHEN T1.Name = 'Subassembly' THEN 1 ELSE 0 END) / COUNT(T2.WorkOrderID) FROM Location AS T1 INNER JOIN WorkOrderRouting AS T2 ON T1.LocationID = T2.LocationID