Which SQL function is used to calculate the average value of a numeric column?OptionsCOUNT()AVG()MAX()SUM()

Answer

The SQL function used to calculate the average value of a numeric column is AVG().

Explanation

The AVG() function takes a column name as an argument and returns the average (mean) of the numeric values in that column. It is commonly used in SQL queries to obtain statistical insights from the data stored in a database table. The other functions listed, such as COUNT(), MAX(), and SUM(), serve different purposes:

1. COUNT(): Counts the number of rows in a dataset.
2. MAX(): Returns the maximum value from a specified column.
3. SUM(): Calculates the total sum of a numeric column.

In summary, if you want to find the average value from a numeric column in SQL, you should use the AVG() function.