To group columns when creating a query:
On the results page, drag and drop the column name you want to group by.
View the number of entries per result.
Example: Drag Employee ID column, into the grey bar where it is mentioned Drag a column and drop it here to group by that column.