Question · SQL and MySQL course · Module 6: Aggregation and grouping

HAVING and aggregate functions

What distinguishes HAVING from WHERE regarding conditions?

Answer options

  • HAVING can use an aggregate function (e.g. COUNT(*) > 3), while WHERE cannot
  • WHERE can use an aggregate function, while HAVING cannot
  • Both work exactly the same
  • HAVING accepts no conditions at all

You can check the correct answer by solving this task in the CodeWorlds game.