You can create a group from the tracker items and calculate information using aggregation functions. There are two parts of cbQL related to grouping. The first part is the projection, which starts with the SELECT keyword followed by alias pairs, optionally including aggregation functions.

SELECT storyPoints as 'Alias of Story Points', ...

SELECT max(storyPoints) as 'Maximum value of Story Point', ...

The second part is the grouping, which starts with the GROUP BY keyword followed by aliases.

GROUP BY 'Alias of Story Points',...

The alias connects the SELECT and GROUP BY clauses. You cannot add an alias to the projection unless it is part of the GROUP BY section or uses an aggregation function. This rule is similar to SQL.