Summary
In this chapter, we have covered how to use aggregate functions and clauses in Python. We have seen:
How to use MySQL's optimized functions to calculate certain aspects of data results
The ways that MySQL provides for sorting the data before it is returned
How to tell MySQL render unique values
Some of the ways that discrete values return different results than non-discrete ones
How we can instruct MySQL to return alternative averages to the mean and its default for the function
AVG
In the next chapter, we will see how to create joins (using JOIN
) in MySQL for Python.