🙏 We really need your support. We need funding to continue our mission: publishing new lessons and improving the platform. If you can, please support the project with a donation. Help the project now →
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.

Use MySQL syntax to write your answer. Descriptions of tables are provided in the right pane.

Write your request in the field below and click the "Check it!" button.
Tutorial Get hint
Copy code Clear editor

Hi! Could we please enable some services and cookies to improve your experience and our website?

Privacy & Cookie Policy.