Having

SELECT HAVING

Filtering groups by expressions:

For example, select countries with number of cities > 2:

    var res = alasql('SELECT *, COUNT(*) AS cnt FROM City \
                GROUP BY Country \
                HAVING cnt > 2');

Expressions can contain aggregators, like below:

    var res = alasql('SELECT * FROM City \
                GROUP BY Country \
                HAVING COUNT(*) > 2');