SQL Server Course for Beginners with 100+ examples - COUNT() Function

This video tutorial explains how to use the AVG function in SQL to calculate the average value of a numerical column. It provides examples using a products table and an employee table, demonstrating how to display records and calculate the average salary. The tutorial also covers using the WHERE clause to filter results before calculating the average.

What is the primary purpose of the AVG function in SQL?

• To count the number of rows in a table

• To calculate the sum of a numerical column

• To calculate the average value of a numerical column

• To find the maximum value in a column

In the example with the employee table, what SQL command is used to display all records?

• SELECT COUNT(*) FROM employee

• SELECT salary FROM employee

• SELECT * FROM employee

• SELECT AVG(salary) FROM employee

What is the average salary calculated in the example with the employee table?

• 7283

• 6000

• 5000

• 8000

How can you modify the AVG function to only consider employees with a salary above 6000?

• By using a WHERE clause

• By using an ORDER BY clause

• By using a HAVING clause

• By using a GROUP BY clause

What is the result of using the AVG function with a WHERE clause filtering salaries greater than 6000?

• It calculates the average of salaries less than 6000

• It calculates the average of all salaries

• It returns an error

• It calculates the average of salaries greater than 6000