Using Statistical Functions in MySQL

Basic Data Analysis with MySQL Functions

MySQL comes with about 30 built-in mathematical and statistical functions giving users access to the most common activities such as mean, standard deviation, min/max and sum. There are also constants built-in for PI and Euler's constant. This allows some data analysis tasks to be implemented with minimal effort.

The tutorial below demonstrates a number of examples of mathematical functions in action.

You may also be interested in:

Creating Databases and Loading Data

Basic MySQL Queries

INNER and OUTER JOINS

Using MySQL Text Functions

Statistics with MySQL

IF, CASE WHEN THEN

You can download the data and code .