🇬🇧 Limited Time — UK Only·🎓 Free Learning for 1 Month·🤖 Free AI Training Included·📚 4,000+ Lessons · 35,000+ Quizzes·🏆 GCSE Mocks · Olympiad Papers·⚡ Selected Students Only · Limited Places·🎁 Free Value Worth £2,000·🇬🇧 Limited Time — UK Only·🎓 Free Learning for 1 Month·🤖 Free AI Training Included·📚 4,000+ Lessons · 35,000+ Quizzes·🏆 GCSE Mocks · Olympiad Papers·⚡ Selected Students Only · Limited Places·🎁 Free Value Worth £2,000·🇬🇧 Limited Time — UK Only·🎓 Free Learning for 1 Month·🤖 Free AI Training Included·📚 4,000+ Lessons · 35,000+ Quizzes·🏆 GCSE Mocks · Olympiad Papers·⚡ Selected Students Only · Limited Places·🎁 Free Value Worth £2,000·
🗄️ Databases

GROUP BY — Summarising Groups

GROUP BY groups rows that share a value, then you can run aggregate functions on each group. For example: total points per team, or average score per class. HAVING filters groups (like WHERE, but for groups).

3 min 10 XP Lesson 9 of 11
GROUP BY — Summarising Groups

GROUP BY groups rows that share a value, then you can run aggregate functions on each group. For example: total points per team, or average score per class. HAVING filters groups (like WHERE, but for groups).

Quick Quiz

1 / 2

What does GROUP BY do?