As talked over within the Syntax and Supported Clauses segment, Team BY clause would be to filter and organize the documents efficiently, and group the outcome of a question dependant on one or more columns as objects while in the reaction. You should use the GROUP BY clause on both of those aggregate and non-aggregate capabilities.I'm Amarjeet Sin