chapter 8 : Grouping

3. Group By Count

Group by Count counts the number of records in each group.

Example

RegionSales
East100
East200
West150
West250
West100

Result (Group by Count):

RegionNumber of Orders
East2
West3