sql-aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

sum() count() average() json_agg()

Question 2

What is the purpose of a group by clause?

Answer 2

to separate groups of rows to perform aggregate functions on the groups of rows