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.