Question · SQL and MySQL course · Module 6: Aggregation and grouping
Condition on an aggregate
The condition concerns the result of an aggregation: COUNT(*) > 3. Which clause should you use?
Answer options
- HAVING, because the condition refers to an aggregate function
- WHERE, because WHERE filters everything
- ORDER BY, because it sorts the groups
- FROM, because it selects the table
You can check the correct answer by solving this task in the CodeWorlds game.