HAVING
Similar to where, but this accepts aggregate functions
SELECT
colName
FROM SchemaName.TableName
GROUP BY groupName
HAVING SUM(colName2) > 5 -- Note that this should come after where and group by
Similar to where, but this accepts aggregate functions
SELECT
colName
FROM SchemaName.TableName
GROUP BY groupName
HAVING SUM(colName2) > 5 -- Note that this should come after where and group by