Grouping
You can create a group from the tracker items and calculate information using aggregation functions. There are two different parts of the cbQL which are related to grouping. The first part is Projection which starts with the SELECT keyword followed by alias pairs with optionally aggregation function.
SELECT storyPoints as 'Alias of Story Points', ...
SELECT max(storyPoints) as 'Maximum value of Story Point', ...
Another part is the grouping part starts with 'GROUP BY' followed by aliases.
GROUP BY 'Alias of Story Points',...
The alias is the connection between the select and the grouping part. It is not possible to add alias to the Projection which is not part of the Grouping section except if it uses aggregation function. The rule is similar like to SQL: