Rules for Aliases in DBOPs that Contain Aggregate Functions

If your database operation includes a SQL statement that involves aggregate functions such as SUM, you must use aliases for any column names to which such aggregate functions refer.

Each alias must follow the rules for valid JavaScript identifiers:

Every alias must begin with a letter, an underscore (_), or a dollar sign ($).
Every character after the first character must be a letter, number, underscore (_), or dollar sign ($).
All characters must be valid ASCII characters.
Do not use a JavaScript reserved word as an alias.

For example, in the following SQL statement, dollarsum is an alias for the sum of the column named DOLLARS.

SELECT
sum(DOLLARS) dollarsum, CUSTOMERID FROM sales GROUP BY CUSTOMERID
ORDER BY CUSTOMERID