aggregate function group by vs where code example

Example: group function vs aggregate function

SAME THING
Multiple Row Functions (Group functions, Aggregate functions):
(Count, MIN , MAX, AVG, SUM)
will run for multiple rows and return a single value