How do you handle NULL values in aggregate functions, and what are the potential pitfalls of ignoring them?
