Multiple choice technology web technology

Which are the following are illegal Queries while using group Functions.

  1. You cannot use the WHERE clause to restrict groups.

  2. You cannot use the HAVING clause to restrict groups

  3. You cannot use group functions in the WHERE clause

  4. None of these
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

In SQL, group functions (like SUM or AVG) cannot be evaluated in the WHERE clause, and the WHERE clause itself cannot filter grouped results. The HAVING clause must be used instead, making both selected options correct descriptions of illegal queries.

Keep practicing — related questions