You are working as a Fabric Analytics Engineer and have been tasked with optimizing the performance of a SQL query in a Fabric lakehouse environment. The dataset contains customer orders with fields such as order ID, product ID, quantity, and order date. Your goal is to retrieve the total quantity of each product ordered in the last 30 days, grouped by product ID, while ensuring the query is efficient and cost-effective. Consider the following constraints: the solution must minimize compute resources, adhere to compliance standards by not exposing sensitive data, and be scalable for large datasets. Which of the following SQL queries best meets these requirements? (Choose one option)