Support the project! The site exists thanks to the community. If the help covers the expenses - the platform remains free. ☕ Support →
SQL code copied to buffer

SQLtest.online
Task 43: 
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!" button.

Get hint Voice input Stop listening Clear answer
Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $29.58 Goal: $100.00
Progress: 30%
SQL in 10 Minutes a Day by Ben Forta
SQL in 10 Minutes a Day by Ben Forta
Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.