Multiple choice technology programming languages

We can use Group functions in the WHERE clause

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Standard SQL does not allow group (aggregate) functions like SUM, AVG, or COUNT directly in the WHERE clause because the WHERE clause filters rows before grouping occurs. To filter groups based on aggregate results, the HAVING clause must be used instead, making the statement false.

Keep practicing — related questions