Question
How does SQL AVG normally treat NULL measure values?
Select an option. Your answer will be checked instantly.
Correct Answer: C. It excludes NULL values from both the numerator and count
Explanation:
AVG computes the sum of non-NULL values divided by their non-NULL count.
Replacing NULL with zero changes the business meaning and must be deliberate.
Leave a Reply