Suppose, you have a table and you want to compute the average value for all the rows in a table or for some subset of rows. For example, you would like to compute the average LifeExpectancy of humans across all countries or may be you would like to compute the
If you want to calculate the average value of a column, you can simply apply the AVG() function to that column.
SELECT AVG(LifeExpectancy) as avg_life_expectancy FROM country
To calculate the average life expectancy by continent, we have to first group the data by Continent using the GROUP BY then apply the AVG() function to the LifeExpectancy column.
SELECT Continent, AVG(LifeExpectancy) as avg_life_expectancy FROM country GROUP BY Continent
If you like this post then please share it with others and subscribe to our blog below to learn data science.