What is the effect of the “GROUP BY” clause on column function?
The column function will calculate its result based on the individual groups created by the GROUP BY specification. In other word, if 500 groups were created by a GROUP BY clause, there would be 500 individual results_one for each group.