In this chapter, you will learn how to use aggregate functions to group and summarize data. Aggregate functions include math functions such as AVG, SUM, COUNT, MIN, and MAX. You will also learn how to use the GROUP BY and HAVING clauses in conjunction with the aggregate functions. Finally, you will learn how MySQL executes your query clauses.
In this chapter, we will cover the following topics:
- Understanding aggregate functions
- Using the GROUP BY clause
- Using the HAVING clause
- Understanding SQL query order of execution
Let's get started!
