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

WHERE/HAVING rule of thumb

The condition concerns an ordinary column: dostepna = 1. Which clause should you use?

Answer options

  • WHERE, because the condition concerns individual rows, not an aggregate
  • HAVING, because every condition requires HAVING
  • Both at once, otherwise the query will not work
  • GROUP BY, because it is a grouping condition

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