We want to filter the results returned based on an aggregate function such as COUNT or SUM.
The WHERE clause may not be used for this. The WHERE conditions are considered before the aggregation.
SELECT winner FROM nobel GROUP BY winner HAVING COUNT(winner)>1
|Specific to SQLite|