sql-aggregates Flashcards
1
Q
What are some examples of aggregate functions?
A
SUM: calculates the sum of values in a set of values
AVG: calculates the average of values in a set of values
MIN: calculates the minimum value in a set of values
MAX: calculates the maximum value in a set of values
2
Q
What is the purpose of a group by clause?
A
to group rows that have the same values in specified columns and return a summary result for each group
