Menu

SQL Query for Calculate Average


The SQL AVG() function is used to calculate average of numbers.

SQL AVG() Syntax

SELECT AVG(column_name)
FROM table_name
WHERE condition;

SQL AVG() Example

In this example we calculate the average run of Virat kohili in 3 match.

MatchNo Name Run Wicket
1 Virat 78 1
2 Virat 82 2
3 Viart 50 0

SQL Query

SELECT COUNT(Run)
FROM students_data;

Output

70.00








Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe