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 was the average salary calculated in the example?

What clause can be added to the AVG function to filter results based on salary?