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 inventory data for the current year. The warehouse contains a table named 'Inventory' with columns 'ItemID', 'ItemName', 'StockDate', and 'Quantity'. Write a SQL query that retrieves the total quantity of each item for the current year. How would you structure this query?