Multiple choice technology platforms and products

Group functions include nulls in calculations

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL group functions (aggregate functions like COUNT, SUM, AVG, MAX, MIN) explicitly EXCLUDE null values from their calculations, except for COUNT(*) which counts all rows regardless of nulls. This is standard SQL behavior - nulls are ignored in aggregates because they represent unknown/missing values. For example, SUM(null_column) returns NULL, not zero, and AVG excludes null rows from both numerator and denominator.

Keep practicing — related questions