Aggregate window functions are used to perform operations on sets of rows in a window(s). They include SUM() , MAX() , COUNT() , and others. Rank window functions are used to rank rows in a window(s).

So I am trying to write an update statement that uses two factors to determine the new value of the field, one of the factors is an aggregate function (COUNT). I get the error: An aggregate may ...