Having
The 'HAVING' Clause
The having clause is like the WHERE clause except you can use aggregate functions like COUNT() and SUM() with it.
SELECT Age, Name, COUNT(Name)
FROM Person
GROUP BY Age
HAVING COUNT(Name) > 50
The having clause is like the WHERE clause except you can use aggregate functions like COUNT() and SUM() with it.
SELECT Age, Name, COUNT(Name)
FROM Person
GROUP BY Age
HAVING COUNT(Name) > 50