In SQL, an aggregate function is a function where the operation is performed on a groups of values to get the end result.
The aggregate functions in SQL are: max, min, count, avg, sum.
Group by is not an aggregate function even though it works on a group, because it doesn't generate one single value as the end result.
Option A