How does one define a GROUP BY condition in Query Builder?
From the OBJECT PALETTE, drag table into WORKSPACE.
Select the COLUMNS desired on the dragged TABLE.
In the left hand panel, under the SELECT grouping, right click on the desired COLUMN that GROUP BY condition needs to be applied.
Select "Include in GROUP BY Clause"
In the GROUP BY Definition window, the condition can be set.