SQL Aggregates Flashcards

1
Q

What are some examples of aggregate functions?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is the purpose of a group by clause?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly