Multiple choice

Which of the following complex expressions is not allowed in SQL?

  1. LOG(marks)*√total

  2. MIN(Col1+col2)

  3. SUM(marks)/COUNT(marks)

  4. AVG(marks)

  5. COUNT(*)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Aggregate functions do not work on complex mathematical expressions like log and square root.

Keep practicing — related questions