Final answer:
The AVG function includes NULL values when calculating the average of numeric values in a specified column by default. However, you can exclude NULL values by using the WHERE clause to filter them out before applying the AVG function.
Step-by-step explanation:
The AVG function is used in databases to calculate the average of a specified column. By default, the AVG function includes NULL values when calculating the average of the numeric values in the column.
For example, if we have a column with the values 10, 20, NULL, and 30, the AVG function will consider the NULL value and calculate the average as (10 + 20 + 0 + 30)/4 = 15.
If you want to exclude NULL values from the calculation, you can use the WHERE clause to filter out the NULL values before applying the AVG function.