Multiple choice technology programming languages

You can use Avg or Sum group functions for any numeric data?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Group functions like AVG and SUM can only be used on numeric columns that contain actual numeric data. They cannot be used on non-numeric data types (strings, dates, etc.) even if they appear numeric - the underlying data type matters. Additionally, these functions ignore NULL values in the numeric columns.