Explore Library
Flashcard

Joins with GROUP BY and HAVING

How to aggregate joined tables and filter groups correctly using GROUP BY and HAVING.

Question

When joining tables and aggregating, what's the difference between WHERE and HAVING?

Click to reveal answer