Many aggregate functions are available in MySQL. The commonly used functions are discussed in this chapter.

In this chapter, we are considering the following books table.

Function: Count()

Function: Sum()

Function: Avg()

Function: Max()

Function: Min()