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?

Simulated

SELECT ItemID, ItemName, SUM(Quantity) AS TotalQuantity FROM Inventory WHERE StockDate >= DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0) GROUP BY ItemID, ItemName;

75.0%

SELECT ItemID, ItemName, SUM(Quantity) AS TotalQuantity FROM Inventory GROUP BY ItemID, ItemName;

8.3%

SELECT ItemID, ItemName, Quantity AS TotalQuantity FROM Inventory WHERE StockDate >= DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0);

16.7%

SELECT ItemID, ItemName, Quantity AS TotalQuantity FROM Inventory;

0.0%

Microsoft Fabric Analytics Engineer Associate DP-600

Get started today

Comments