Lesson 2.2 · Pro
GROUP BY: one row per group
Split rows into groups and summarise each group.
In this lesson
- One row per group
- Group by more than one column
- The GROUP BY rule
- Shorthand: GROUP BY 1, 2
- Sort the groups
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.