Organizing Data in a Column Using Operators

The GROUP BY section of the query editor lets you group the results of the operation by another column in the data source. Use GROUP BY to get aggregated information of all the values in a column, such as the values' average or maximum.

Example: In the SELECT section, you specify an operator to find students' grade point averages and standings. You want to find the average GPA for students in each grade. In the GROUP BY section, you can select the Grade column, which will show you the average GPA for students in each grade. This configuration looks like the following: