chapter 8 : Grouping

4. Group By Minimum

Group by Minimum finds the smallest value in each group.

Example Result

RegionMinimum Sales
East100
West100

Explanation

  • East: min(100, 200) = 100

  • West: min(150, 250, 100) = 100