sql-aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

avg()
sum()
count(*)
count()
max, min

Question 2

What is the purpose of a group by clause?

Answer 2

The GROUP BY statement groups rows that have the same values into summary rows