Window functions with aggregations (I)
To familiarize yourself with the window functions, you will work with the Orders
table in this chapter. Recall that using OVER()
, you can create a window for the entire table. To create partitions using a specific column, you need to use OVER()
along with PARTITION BY
.
This exercise is part of the course
Intermediate SQL Server
Exercise instructions
Write a T-SQL query that returns the sum of OrderPrice
by creating partitions for each TerritoryName
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT OrderID, TerritoryName,
-- Total price for each partition
___
-- Create the window and partitions
___(___ TerritoryName) AS TotalPrice
FROM Orders