Suppose you are writing a SQL query. You want to aggregate the records into groups and calculate the average value of a field for each group.

The key word you would use to group records is $q,$

aggregating by

grouping by

group by

aggregate by