How to Add Aggregations and Functions
After you have added the necessary fields or objects to the query, you can apply aggregation or other functions to them. To do it, simply click the field in the Result Fields pane and then select the necessary function in the Details pane on the right side of the page. Note that the Details pane displays only the functions applicable to the type of the selected column. The list of Supported SQL Functions contains the supported aggregation and expression functions for the column types.
When you apply aggregation functions to selected columns, columns without an aggregation function selected are automatically added to the GROUP BY clause. You don’t need to configure this clause manually.
To remove a function from a column, simply select the column in the Result Fields pane and then, in the Details pane, click Value.