Introduction to MySQL aggregate functions An aggregate function performs a calculation on multiple values and returns a single value. For example, you can use the AVG() aggregate function that takes ...

-- MySQL's aggregate function is used to perform calculations on multiple values and return the result in a single value like -- the average of all values, the sum of all values, and maximum & minimum ...

An aggregate function includes values grouped together to form a single value that provides a summary of the data list.

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 ...