SQL HAVING #
Sort of like a WHERE, but the target is a GROUP and the condition is based on some sort of aggregation of the group.
SELECT <field_1>, <field_2>
FROM <table>
GROUP BY 1
HAVING <AGGREGATION>(field_1) > <integer>;
HAVING
Sort of like a WHERE, but the target is a GROUP and the condition is based on some sort of aggregation of the group.
SELECT <field_1>, <field_2>
FROM <table>
GROUP BY 1
HAVING <AGGREGATION>(field_1) > <integer>;