Adding GROUP BY and aggregate functions

To enable the use of GROUP BY and aggregate functions in your query, right-click the gray background in the top half of the screen, and then select Group By from the right-click menu.

This adds a Group By column to the grid on the lower half of the screen.

To set the options for each cell in the Group By column, click the cell and then choose an option from the drop-down menu.  

Options available in the Group By column include clause identifiers and aggregate functions.

The clause identifiers include:

The aggregate functions include:

 

More:

Hiding a column from the query results

Setting an alias for the column

Adding columns to the query

Setting the sort order

Adding criteria for the column

Working with columns in a SELECT query