You have a Fabric warehouse containing a table named SalesOrderDetail. The table has three columns: OrderQty, ProductID, and SalesOrderID. There is one row for each unique combination of SalesOrderID and ProductID.

You need to calculate the proportion of the total order quantity for each sales order that is represented by each product within that sales order.

Which T-SQL statement should you execute?