By and Total

group_field: The field to group by (e.g., TEAM ).
field_to_sum: The numeric field to sum for each group (e.g., PLACE ).

Syntax

By                  group_field
Total               field_to_sum

Used with the By command to calculate a sub-total for a specific numeric field for each group.

This combination provides a way to get totals for each category defined by the By command. For example, it can be used to sum team scores.

To get a total score for each team by summing the PLACE field:

Select              TEAM
NE
By                  TEAM
Total               PLACE