1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL Server

Exercise

Creating running totals

You usually don't have to use ORDER BY when using aggregations, but if you want to create running totals, you should arrange your rows! In this exercise, you will create a running total of OrderPrice.

Instructions

100 XP

Create the window, partition by TerritoryName and order by OrderDate to calculate a running total of OrderPrice.