FactEngine Query Language (FEQL) has a GROUP BY clause analogous to the GROUP BY clause in SQL and Cypher query languages.
GROUP BY clauses may be used in conjunction with a RETURN clause which is analogous to SELECT and RETURN clauses in the SQL and Cypher query languages.
For example, the following FEQL query has a RETURN, GROUP BY and ORDER BY clause, for a query that returns the count of orders taken by employees in December 2017 in descending order, over a database that stores orders for products (the Northwind database by Microsoft):
Syntax - GROUP BY Clause
<GROUPBYCLAUSE> ::= <KEYWDGROUPBY> <GROUPBYRETURNCOLUMN> (<COMMA> <GROUPBYRETURNCOLUMN>)*
<GROUPBYRETURNCOLUMN> ::= <MODELELEMENTNAME> <MODELELEMENTSUFFIX>? <PERIOD> <COLUMNNAMESTR>
<COMMA> ::= ,
<KEYWDGROUPBY> ::= GROUP BY
<MODELELEMENTNAME> ::= @"(([A-Z0-9]+[_a-z\-0-9]+[ |_]*)+[_|\s]?)+"
<MODELELEMENTSUFFIX> ::= @"([0-9])+"
<PERIOD> ::= .
<COLUMNNAMESTR> ::= @"(([a-zA-Z0-9][_a-z0-9]+)+[_|\s]?)+";
See Also: RETURN Clause