Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
You are working with a data warehouse in Fabric that contains a table named 'Orders' with columns 'OrderID', 'CustomerID', 'OrderDate', and 'TotalAmount'. You need to write a SQL query to find the top 5 customers who have spent the most in the last year. How would you structure this query?
You are working with a data warehouse in Fabric that contains a table named 'Orders' with columns 'OrderID', 'CustomerID', 'OrderDate', and 'TotalAmount'. You need to write a SQL query to find the top 5 customers who have spent the most in the last year. How would you structure this query?
Simulated
A
SELECT TOP 5 CustomerID, SUM(TotalAmount) AS TotalSpent FROM Orders WHERE OrderDate >= DATEADD(year, -1, GETDATE()) GROUP BY CustomerID ORDER BY TotalSpent DESC;
91.7%
B
SELECT CustomerID, SUM(TotalAmount) AS TotalSpent FROM Orders WHERE OrderDate >= DATEADD(year, -1, GETDATE()) GROUP BY CustomerID ORDER BY TotalSpent DESC;
Comments
Loading comments...