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?