Kollidierende
New Member
What does AVG do with columns with NULL values if we compute AVG over that column? Does it compute the average by considering NULL as zeroes or it computes average by excluding null values?I can do it by creating a demo table, but I'm in hurry and need some quick answers. Whole assignment is revolving around this point.