Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are tasked with querying a warehouse in Fabric to extract sales data for the current year. The warehouse contains a table named 'Sales' with columns 'SaleID', 'ProductID', 'CustomerID', 'SaleDate', and 'Amount'. Write a SQL query that retrieves the total sales amount for each product in the current year. How would you structure this query?