Group By Clause
The GROUP BY clause is supported, with the following Entry SQL level restrictions:

The COLLATE clause is not supported.

SELECT DISTINCT is not supported for queries which also have a GROUP BY clause.

The grouping column reference cannot be an alias. The following queries fail because
fc is an alias for the
intcol column:
SELECT intcol AS fc, COUNT (*) FROM p_gtable GROUP BY fc
SELECT f(col) as fc, COUNT (*) FROM table_name GROUP BY fc