Get startedGet started for free

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

View Course

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
Edit and Run Code