Note: The task description says “find the percentage contribution of each product’s sales to the total sales.” This wording suggests that sales should first be aggregated by ProductID. However, the query in the example calculates the percentage at the order level, meaning each order’s sales is compared to the total sales.

A clearer task description would be: “Find the percentage contribution of each order’s sales to the total sales.”