Describe the main SQL aggregate functions and explain how GROUP BY works. How would you use these to summarize sales data?

Sample answer preview

Aggregate functions perform calculations across a set of rows and return a single summary value. Combined with GROUP BY, they form the backbone of analytical SQL queries that BI analysts write daily. The five core aggregate functions are COUNT, SUM, AVG, MIN, and MAX.