Excellent! It's time to look at another type of window frame: RANGE.

The difference between ROWS and RANGE is that RANGE will take into account all rows that have the same value in the column which we order by. This might be helpful with dates. Consider the following problem: we want to calculate the running sum from all orders sorted by date. We could write something like this:

SELECT
  Id,
  PlacedDate,
  TotalPrice,
  SUM(TotalPrice) OVER(ORDER BY PlacedDate ASC ROWS UNBOUNDED PRECEDING) AS RunningSum
FROM SingleOrder;

And it would work. But our boss might say "Hey, I don't really need to see how the running sum changed during single days. Just show the values at the end of the day. If there are multiple orders on a single day, add them together".

This can be implemented by changing ROWS to RANGE. Notice how we've highlighted the rows which now share the same running sum because they come from the same date.

SELECT
  Id,
  PlacedDate,
  TotalPrice,
  SUM(TotalPrice) OVER(ORDER BY PlacedDate ASC RANGE UNBOUNDED PRECEDING) AS RunningSum
FROM SingleOrder;