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.