Multiple choice

Which of the following is not true about aggregate functions?

  1. MAX and MIN functions work on numeric and non-numeric data.

  2. SUM and AVERAGE work on numeric data.

  3. Aggregate functions do not work on complex mathematical expressions like log, square root, etc.

  4. SUM and AVERAGE work on non-numeric data.

  5. There is no influence of distinct keywords in aggregate function.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

MIN and MAX functions work on non-numeric data, but SUM and AVERAGE do not work on non-numeric data.

Keep practicing — related questions