SQL Aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

sum()
count()
avg()
max()
min()
every()

Question 2

What is the purpose of a group by clause?

Answer 2

you want to separate rows into groups and perform aggregate functions on those groups of rows