What does the following query demonstrate about NULL handling in aggregates? SELECT AVG(bonus) FROM employees

Explanation

The query SELECT AVG(bonus) FROM employees demonstrates that AVG ignores NULL values and only divides the sum by the count of non-NULL rows. This can potentially give a misleading result if not handled correctly.

Key points

AVG in SQL excludes NULL values from the calculation
It divides the sum by the count of non-NULL rows
This can lead to inaccurate results if NULL values are not accounted for
Understanding NULL handling in aggregates is crucial for accurate calculations

Ready to go further?

Start full exam Practice more questions