sql-aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

APPROX_COUNT_DISTINCT.
AVG.
CHECKSUM_AGG.
COUNT.
COUNT_BIG.
GROUPING.
GROUPING_ID.
MAX.

Question 2

What is the purpose of a group by clause?

Answer 2

To organize similar data into groups.