sql-aggregates

Question 1

What are some examples of aggregate functions?

Answer 1

count(),sum(),avg() (many more functions available)

Question 2

What is the purpose of a group by clause?

Answer 2

when you want to isolate rows into a separate group and perform aggregate functions on those group of rows you can use group by clause