The GROUP BY clause orders the result set according to an alias specified in the SELECT statement.
Syntax
GROUP BY [alias]...
Notes
In this instance, the alias may be used as a simple column reference to a database table, or an actual expression composed of arithmetic expressions, character operators, date operators, or scalar functions. The alias is essentially an alternate name.
Example
In the following example, the GROUP BY clause refers to the "CityState" phrase of the SELECT statement:
SELECT CONCAT (State, City) AS "CityState",
COUNT (city)
FROM Pub.Customer
GROUP BY "CityState";
