SQL-Aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

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

Question 2

What is the purpose of a group by clause?

Answer 2

To perform aggregate functions on a specific group of rows