The group by statement is used to aggregate data and find the aggregated values of numerical columns. The keyword for performing this operation is the same, but the syntax is a little different. Let's look at a few examples.
Suppose we are looking to find the numbers of active and inactive customers in the dataset. This can be done as follows in the two tools.