# SQL sum(), count() and avg() functions With Examples [Latest]

Oct 22, 2022

Hey, readers! In this article we will be focusing on some of the extensively used aggregate functions of SQL — sum(), count() and avg() function.

## SQL sum() function

The `SQL sum() function` does the summation of all the values of a particular column of a respective table and returns the value obtained as the summation of it.

Syntax:

In the above syntax, the `WHERE clause` is used to act upon a condition provided ahead of it.

Example 1:

In the above example, we have created a Table ‘Info’ containing columns ‘id’ and ‘Cost’. Further, we have used SQL sum() function to depict the summation of all the data values present in the column ‘Cost’.

Output:

Example 2:

In this example, SQL WHERE clause is used to select only those data values of the column ‘Cost’ that have values greater than 20. These selected data values are passed to the SQL sum() function for summation of the values.

Output:

### SQL sum() function with GROUP BY clause

The `SQL GROUP BY clause` is used along `SELECT statement` to group identical data values against some particular group values.

Syntax of SQL GROUP BY clause:

Example:

In this example, the GROUP BY clause is been used to group the identical data values of column ‘City’ by groups.

Further, these set of data values are passed to SQL sum() function and it performs summation of elements of those groups separately.

Output:

## SQL count() function

`SQL count() function` counts the total number of data values present in a particular column passed to it.

Syntax:

Example 1:

In the above example, we have displayed a count of data values present in the column ‘id’ using SQL count() function.

Output:

Example 2:

Considering the Table of Example 1, we have used SQL count() function alongside WHERE clause to count only those data values that happen to belong to the City ‘Pune’.

Output:

### SQL count() function with GROUP BY clause

SQL count() function can be clubbed alongside GROUP BY clause to get the count of data values against a particular group of data.

Example:

In the above example, we have used SQL GROUP BY clause to group the data values by the column ‘city’. After which, we have used the SQL count() function to calculate the number of data values associated to that particular groups formed.

Output:

## SQL avg() function

`SQL avg() function` estimates the average of data values of a particular column passed to it.

Syntax:

Example 1:

Referring to the Table created in the above section, we have used SQL avg() function to calculate the average of data values of the column ‘Cost’.

Output:

Example 2:

In this example, we have calculate the average value of the data elements which belong to the city ‘Pune’.

Output:

### SQL avg() function with GROUP BY clause

SQL avg() function along with GROUP BY clause is used to calculate the average of data values against respective groups of data.

Example:

We have grouped the data values along the column ‘city’ and then calculated the average value of the data belonging to identical city.

Output:

## Conclusion

By this, we have come to the end of this topic. I hope all the queries have been answered by the above content.

Please feel free to comment below in case you come across a doubt.