Explanation

Group By summarizes data based on one or more columns.

Example:

Group by City:

Available Operations

• Sum
• Count Rows
• Count Distinct Rows
• Average
• Min
• Max

Practice

Create a City-wise Sales Summary using Group By.