sql-aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

The max(), avg(), count(), min(), sum(), and every() functions are examples of aggregate functions

Question 2

What is the purpose of a group by clause?

Answer 2

To separate rows into groups and perform aggregate functions on those groups of rows.