Use HAVING to Filter Aggregated Results

SQL

Technical Specification

Count users per country but only show countries having more than 100 users.

Input/Output Samples

Input:users per country > 100

Output:Filtered list of countries

Optimal Logic Path

SELECT 
  country,
  COUNT(*) AS user_count
FROM users
GROUP BY country
HAVING COUNT(*) > 100;

Architectural Deep-Dive

HAVING filters groups after aggregation, whereas WHERE filters rows before grouping.