Check out a free preview of the full SQL Fundamentals course:
The "Aggregate Functions and GROUP BY" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
Often, there are situations when we want to summarize data that is aggregated over a result set. For example, a possible query would be “give me the number of products we have in each category." Through using GROUP BY, Mike shows how to define the records using aggregate functions like sum, count, group_concat to aggregate over duplicate data.