Keep SQLtest alive: Help cover this month's $100 server costs to keep all lessons and the SQL playground online. Support the project →
SQL code copied to buffer
Task 43:

What is the difference between HAVING and WHERE?

Explain, in your own words, the difference between the WHERE clause and the HAVING clause in SQL. Mention when each one is used and give a short example of a query where only HAVING would work correctly.

Write your answer in the field below and click the "Check answer" button.

Tutorial
Answers are checked by AI, so checking needs an account. New accounts get free AI tokens.
The AI feedback on your answer will appear here.