Question

Consider the following SQL.

SELECT ______ FROM Employee WHERE Dept= 'Printing';

Which of the following should be used to find the mean of the salary?

Options

• Mean(Salary) 

• Avg(Salary)

• Sum(Salary) 

• Count(Salary)

Answer 1

Avg(Salary)

Explanation:

The AVG() function returns the average value of a numeric column. AVG() Syntax. SELECT AVG(column_name) FROM table_name. WHERE condition;.