The SQL AVG() function is used to calculate average of numbers.
SELECT AVG(column_name)
FROM table_name
WHERE condition;
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 |
SELECT COUNT(Run)
FROM students_data;
70.00